NTSB investigations

19,008 cases where NTSB found Personnel issues.

Cases, newest first

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB ERA12IA237Incident · No injuriesIncident investigationFinal reportPiper PA-32R-300 · Warrenton, VAMaintenance personnel's failure to identify stress corrosion cracking in the stabilator control cable during the most recent inspection, and the subsequent failure of the cable on the flight after the inspection.Mar 14, 2012 · N1358H · No damageNTSB CEN12LA187Accident · 1 fatalLimited investigationFinal reportBrice Ron Glastar Sportsman 2+ · Kimberling, MOThe pilot’s inadequate flare, which resulted in the airplane impacting into the water.Mar 13, 2012 · N627RM · Substantial damageNTSB ANC12LA026Accident · Serious injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 · Ketchikan, AKThe pilot's decision to depart in marginal visual meteorological conditions, and his continued visual flight into instrument meteorological conditions.Mar 13, 2012 · N82SF · Substantial damageNTSB WPR12CA129Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Santa Clarita, CAThe pilot's delayed decision to abandon the landing attempt, which resulted in the airplane colliding with rising terrain. Contributing to the accident was the pilot's decision to land with a tailwind.Mar 12, 2012 · N4143C · Substantial damageNTSB CEN12CA191Accident · No injuriesData collectionFinal reportBell 206L-3 · Southern Timbalier 52CAThe pilot’s inadequate preflight inspection when he did not remove a tie-down strap prior to takeoff, which resulted in a dynamic rollover.Mar 12, 2012 · N104LP · Substantial damageNTSB WPR12LA128Accident · No injuriesLimited investigationFinal reportBeech 76 · Rio Linda, CAA loss of engine power due to carburetor icing, and the pilot's failure to use carburetor heat during descent while operating in an area conducive to carburetor icing.Mar 11, 2012 · N6697L · Substantial damageNTSB ANC12CA025Accident · No injuriesData collectionFinal reportHughes 369 · Trading Bay, AKThe pilot's selection of an unsuitable landing site in flat-light conditions, which resulted in an inadvertent dynamic rollover.Mar 11, 2012 · C-GVEB · Substantial damageNTSB ERA12CA222Accident · Minor injuriesData collectionFinal reportCessna 172N · Orleans, VTThe pilot’s failure to maintain clearance from a power line while conducting low-altitude flight.Mar 10, 2012 · N738QF · Substantial damageNTSB WPR12CA127Accident · No injuriesData collectionFinal reportCessna 172N · Kelso, WAThe pilot did not maintain directional control during the landing flare.Mar 9, 2012 · N5290D · Substantial damageNTSB ERA12LA219Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Homestead, FLThe inadequate servicing and maintenance of the engine and the airplane owner and maintenance personnel's disregard of the manufacturer's recommended engine overhaul schedule and service bulletins, which resulted in an in-flight internal failure and seizure…Mar 9, 2012 · N444VR · Substantial damageNTSB ANC12CA027Accident · No injuriesData collectionFinal reportCessna U206G · Naknek, AKThe pilot's decision to take off from an unsuitable off-airport site.Mar 9, 2012 · N756CL · Substantial damageNTSB WPR12LA126Accident · No injuriesLimited investigationFinal reportQuicksilver MX Sprint II · Willits, CAThe student pilot did not maintain an adequate approach/glide path and altitude, which resulted in a runway undershoot and subsequent collision with trees. Contributing to the accident was the student pilot's lack of flight experience.Mar 8, 2012 · N702U · Substantial damageNTSB OPS12WA430Incident · No injuriesForeign investigationGulfstream Aerospace GV SP (G550) · Ontario, CanadaN217AL, a private Cessna 750, was en route between San Jose, California (KSJC), and Bedford, Massachusetts (KBED) at FL430. N128GV, a private Gulfstream V, was en route between Bradley/Windsor Locks, Connecticut (KBDL), and San Francisco, California (KSFO),…Mar 8, 2012 · N128GV · 2 aircraft · No damageNTSB CEN12CA183Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Fort Collins, COThe pilot did not maintain adequate airspeed and airplane control during the go-around, which resulted in the airplane impacting trees.Mar 8, 2012 · N2986P · Substantial damageNTSB ERA12CA216Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Hollandale, MSThe pilot's failure to maintain directional control while taxiing in gusty wind conditions.Mar 7, 2012 · N9148C · Substantial damageNTSB ERA12LA210Accident · Minor injuriesLimited investigationFinal reportBell 206B · Titusville, FLThe flight instructor's attempted takeoff in gusting wind conditions while the student pilot was adjusting her anti-torque pedals, which resulted in a dynamic rollover event.Mar 6, 2012 · N83AP · Substantial damageNTSB ERA12CA215Accident · No injuriesData collectionFinal reportCessna 140A · Mooresville, NCThe separation of the left rudder cable turnbuckle and the pilot’s subsequent loss of directional control during landing.Mar 6, 2012 · N5693C · Substantial damageNTSB DCA12PA049Accident · 1 fatalFinal reportIsrael Aircraft Industries F21-C2 · Fallon, NVfuel exhaustion following missed approaches due to deficient ATC handling under weather conditions which were significantly lower than forecast. The second missed approach may have been initiated due to limited pilot instrument proficiency. Contributing to…Mar 6, 2012 · N404AX · DestroyedNTSB ANC12IA024Incident · No injuriesIncident investigationFinal reportBombardier Learjet 35A · Anchorage, AKThe flightcrew's loss of visual reference to the runway after encountering severe in-flight icing conditions, which resulted in a loss of control while landing and exceedence of the capabilities of the airplane's windscreen anti-ice systems. Contributing to…Mar 6, 2012 · N544LM · Minor damageNTSB WPR12FA123Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Brockton, MTThe pilot’s failure to maintain adequate airspeed and airplane control while maneuvering at a low altitude, which resulted in a stall and subsequent impact with terrain.Mar 5, 2012 · N5542K · Substantial damageNTSB CEN12LA182Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · East Troy, WIThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Mar 5, 2012 · N6849B · Substantial damageNTSB CEN12LA181Accident · No injuriesLimited investigationFinal reportSikorsky 269C · Staples, TXThe pilot's failure to attain the proper descent rate during autorotation, which resulted in a hard landing. Contributing to the accident were the inflight vibrations and loss of torque pedal response for undetermined reasons.Mar 5, 2012 · N1099N · Substantial damageNTSB WPR12LA122Accident · Serious injuriesLimited investigationFinal reportBowers Fly Baby 1-A · Fallbrook, CAThe pilot did not maintain directional control of the airplane during the takeoff roll.Mar 4, 2012 · N41017 · Substantial damageNTSB WPR12CA132Accident · No injuriesData collectionFinal reportCessna 170B · San Jose, CAThe pilot did not maintain directional control during the landing roll.Mar 4, 2012 · N8245A · Substantial damageNTSB ERA12CA220Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Beverly, MAThe pilot's loss of airplane control during takeoff, which resulted in a runway excursion.Mar 4, 2012 · N7DF · Substantial damageNTSB ERA12CA209Accident · No injuriesData collectionFinal reportCessna 172S · Lafayette, TNThe pilot’s inadequate compensation for gusting crosswind conditions during landing, which resulted in a hard landing.Mar 4, 2012 · N53460 · Substantial damageNTSB ERA12WA212Accident · 1 fatalForeign investigationCessna 172N · Miranda, VenezuelaOn March 3, 2012, about 1259 universal coordinated time, a Cessna 172N, Venezuelan registration, YV105E, was destroyed when it impacted into terrain while in cruise flight near Municipio Zamora Parroquia Bolivar, Miranda, Venezuela. The pilot was fatally…Mar 3, 2012 · YV105E · DestroyedNTSB CEN12LA179Accident · 1 fatalLimited investigationFinal reportSkeeter 1M · Oklahoma City, OKThe pilot's failure to maintain airplane control while on final approach as he was executing a turn to provide spacing between his airplane and an airplane on the runway.Mar 3, 2012 · N1111V · Substantial damageNTSB WPR12CA121Accident · No injuriesData collectionFinal reportSiai-Marchetti SF.260TP · Corona, CAThe pilot did not maintain runway alignment during landing in a gusting crosswind.Mar 2, 2012 · N350TP · Substantial damageNTSB ERA12FA205Accident · 2 fatalField investigationFinal reportCessna LC42-550FG · Salisburry, NCThe non-instrument-rated pilot's decision to continue flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.Mar 2, 2012 · N167ZP · DestroyedNTSB ERA12CA204Accident · Serious injuriesData collectionFinal reportAmerican Champion 7GCAA · Bedminster, NJThe pilot receiving instruction’s inadvertent movement of the pitch trim control to the nose-down position while attempting a go-around.Mar 2, 2012 · N518F · Substantial damageNTSB CEN12LA204Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Roanoke, TXThe pilot’s failure to follow the published emergency procedures to lower the landing gear following a loss of electrical power.Mar 2, 2012 · N373JT · Substantial damageNTSB WPR12TA120Accident · No injuriesFinal reportEurocopter AS 350 B3 · Napa, CAThe flight instructor’s improper use of the collective control during a practice hovering autorotation, which resulted in a hard landing.Mar 1, 2012 · N341HP · Substantial damageNTSB ERA12CA199Accident · No injuriesData collectionFinal reportBell OH-58A · Eufaula, ALThe pilot's inadequate compensation for the gusting wind, which resulted in an excessive descent rate and hard landing.Mar 1, 2012 · N38FA · Substantial damageNTSB ERA12CA198Accident · No injuriesData collectionFinal reportLester Robert E KR-2 · Boca Raton, FLThe failure of the airplane’s engine air inlet system resulting in a total loss of engine power.Mar 1, 2012 · N1701L · Substantial damageNTSB CEN12FA174Accident · 2 fatalField investigationFinal reportHemp Timothy Legacy 2000 · Belen, NMThe pilot’s failure to maintain clearance from power lines while maneuvering after takeoff. Contributing to the accident was the pilot’s decision to operate the airplane during the hours of darkness when he had a restriction for daytime flight only due to…Mar 1, 2012 · N273TE · DestroyedNTSB ERA12FA196Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Melbourne, FLThe pilot's abrupt maneuver in response to a perceived traffic conflict, which resulted in an accelerated stall and a loss of airplane control at low altitude. Contributing to the accident was the air traffic controller's incomplete instructions, which…Feb 29, 2012 · N544SR · Substantial damageNTSB CEN12LA171Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Denver, COThe pilot's improper decision to taxi in wind conditions that exceeded the airplane’s capability.Feb 27, 2012 · N3196F · Substantial damageNTSB ERA12FA194Accident · 2 fatalField investigationFinal reportStrout Frank Aventura II · Laceys Spring, ALThe pilot's failure to maintain control of the airplane during a low-altitude maneuver. Contributing to the accident was the pilot's lack of the required rating to operate the airplane.Feb 26, 2012 · N1193S · Substantial damageNTSB DCA12CA045Accident · Serious injuriesData collectionFinal reportBoeing 767 · Angers, Francethe flight attendant inadvertently tripping over a passenger's luggage strap that was protruding into the isle.Feb 26, 2012 · N829MH · No damageNTSB CEN12FA170Accident · 2 fatalField investigationFinal reportMooney M20E · San Antonio, TXThe pilot's inadvertent overboost of the turbocharged engine during initial climb, which resulted in detonation and a partial loss of engine power followed by the pilot's failure to maintain airspeed and the instructor's delayed remedial action, which…Feb 26, 2012 · N9224M · Substantial damageNTSB WPR12CA118Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Poway, CAThe pilot's inadequate compensation for wind conditions during landing, which resulted in a hard landing.Feb 25, 2012 · N118MB · Substantial damageNTSB ERA12LA195Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Americus, GAThe failure of maintenance personnel to properly secure a portion of the right wing leading edge, which resulted in the separation of the associated section of the leading edge during takeoff and the loss of directional control during the subsequent landing.Feb 25, 2012 · N59661 · Substantial damageNTSB CEN12CA173Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Hebron, NEThe pilot’s did not properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane and collision with a building.Feb 25, 2012 · N1213C · Substantial damageNTSB ERA12FA193Accident · 2 fatalField investigationFinal reportCessna 172S · Key West, FLThe non-night-qualified pilot's improper decision to depart in dark night visual meteorological conditions, which resulted in his subsequent spatial disorientation, loss of control, and impact with water.Feb 24, 2012 · N53589 · Substantial damageNTSB CEN12LA169Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Cypress, TXThe pilot's improper preflight planning/preparation and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion during the approach to the destination airport.Feb 24, 2012 · N99EZ · Substantial damageNTSB WPR12LA119Accident · Serious injuriesLimited investigationFinal reportBoeing 737-7H4 · Pawnee, NEThe airplane's encounter with moderate turbulence during cruise flight, which resulted in a serious injury to a flight attendant.Feb 23, 2012 · N915WN · No damageNTSB WPR12LA113Accident · No injuriesLimited investigationFinal reportHaycraft Sport Hornet · Mariposa, CAImproper clearance and inadequate heat shielding between engine components and the exhaust system, which resulted in an in-flight fire.Feb 21, 2012 · N72PD · Substantial damageNTSB CEN12LA168Accident · No injuriesLimited investigationFinal reportCessna 180H · Conroe, TXThe pilot’s failure to maintain directional control during the landing. Contributing to the accident was the flight instructor’s delayed intervention and the pilot’s lack of experience in tailwheel airplanes.Feb 21, 2012 · N3SM · Substantial damageNTSB CEN12FA164Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Albany, TXThe loss of flight instrumentation due to a failed vacuum pump while flying a night without a discernable horizon, which resulted in the pilot's spatial disorientation and an in-flight loss of control and impact with terrain. Contributing was the continued…Feb 21, 2012 · N7147P · Substantial damage