NTSB investigations

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

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
  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 DEN92LA056Accident · No injuriesLimited investigationFinal reportNorth American Harvard MK-II · Watkins, COThe pilot inadvertently stalling the airplane. Factors included: the pilot's failure to maintain directional control on takeoff, and inadequate airspeed.Jun 8, 1992 · N90541 · DestroyedNTSB ATL92MA118Accident · 3 fatalClass 1 · MajorFinal reportBeech C99 · Anniston, ALThe failure of senior management of gp express to provide adequate training and operational support for the startup of the southern operation, which resulted in the assignment of an inadequately prepared captain with a relatively inexperienced first officer…Jun 8, 1992 · N118GP · DestroyedNTSB SEA92LA121Accident · No injuriesLimited investigationFinal reportMooney M20E · Freeland, WABlockage of the fuel injector servo system. Factors contributing to the accident were: fuel injection system corroded and animals in the landing area.Jun 7, 1992 · N5887Q · Substantial damageNTSB SEA92LA120Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Panguitch, UTShorting of the grounding wire (p lead) to the magnetos followed by overloading of the nose wheel strut. A factor contributing to the accident was: rough/uneven terrain.Jun 7, 1992 · N9035V · Substantial damageNTSB NYC92LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Danville, NYThe decision by the pilot to land during a heavy rain shower, which resulted in a long landing, and his attempted takeoff with insufficient available runway and subsequent loss of airplane control.Jun 7, 1992 · N98276 · Substantial damageNTSB NYC92LA099Accident · 1 fatalLimited investigationFinal reportMurdock/Gates/Field Kolb MK-III · Boonville, NYThe failure of the pilot to maintain proper airspeed, resulting in a stall and loss of airplane control. A factor related to the accident was the student pilot's lack of total flight experience.Jun 7, 1992 · N3146G · Substantial damageNTSB MIA92MA131Accident · 5 fatalMajor investigationFinal reportCASA 212 · Mayaguez, PRThe failure of the beta blocking device for undetermined reason(s), and the second-pilot's inadvertent activation of the power lever, or levers, aft of the flight idle position and into the beta range, resulting in a loss of airplane control.Jun 7, 1992 · N355CA · DestroyedNTSB LAX92LA238Accident · No injuriesLimited investigationFinal reportCessna 177A · Mariposa, CAThe pilot's poorly planned approach for landing, his failure to initiate a go-around, his failure to obtain the proper touchdown point, his misjudgment of the touchdown flare, and his improper recovery from a bounced landing. A factor in this accident was the…Jun 7, 1992 · N3144T · Substantial damageNTSB LAX92LA237Accident · Minor injuriesLimited investigationFinal reportBell 222 · Mariposa, CAThe pilot decision to takeoff and fly with a known deficiency in one of the helicopter's engines.Jun 7, 1992 · N5007L · DestroyedNTSB FTW92LA153Accident · No injuriesLimited investigationFinal reportPokorney Smith Mini DSA-1 · Groom, TXThe pilot's selection of the unsuitable landing area. Factors were the weather condition and the road sign.Jun 7, 1992 · N2MP · Substantial damageNTSB FTW92FA152Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF260B · Decatur, TXThe loss of engine power as the result of the failure of the engine oil pump. Factors were non compliance with a service bulletin, the lack of suitable terrain, and inadvertent stall.Jun 7, 1992 · N22FD · DestroyedNTSB DEN92LA055Accident · 1 fatalLimited investigationFinal reportTakemoto KR-2 · Aurora, COThe pilot failed to maintain airspeed which resulted in an inadvertant stall.Jun 7, 1992 · N3LL · DestroyedNTSB DCA92RA038Accident · No injuriesForeign investigationBoeing 737-204 · Tucuti, PanamaJun 7, 1992 · HP120NTSB CHI92LA164Accident · Serious injuriesLimited investigationFinal reportGrumman AA5B · Charlotte, MIThe pedestrian's failure to maintain visual outlook and separation from the taxiing aircraft.Jun 7, 1992 · N45199 · No damageNTSB ATL92LA119Accident · No injuriesLimited investigationFinal reportChampion 8KCAB · Wallace, NCThe failure of the pilot to maintain directional control during the crosswind landing. A factor was the crosswind condition.Jun 7, 1992 · N7921S · Substantial damageNTSB ATL92GA121Accident · 2 fatalFinal reportEnstrom 280FX · Summerville, SCThe pilot's inadvertent flight into IMC, which resulted in an in flight collision with trees. Factors were the obscured sky and foggy weather conditions, and the night lighting conditions at the time of the accident.Jun 7, 1992 · N86262 · DestroyedNTSB ANC92LA087Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Klutina Lake, AKThe pilo'ts poor inflight planning. Factors include downdrafts, and mountainous/ hilly terrain.Jun 7, 1992 · N4088M · Substantial damageNTSB SEA92LA221Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Spangle, WAAltitude was not attained. A factor to the accident was: load jettison was not possible.Jun 6, 1992 · N4685R · Substantial damageNTSB SEA92LA119Accident · No injuriesLimited investigationFinal reportMooney M20K · Stanley, IDThe failure of the pilot to maintain runway alignment and his loss of directional control during takeoff ground roll, resulting in a swerve off the 150 ft wide runway and impact with a fence. Factors relating to the accident were the lack of runway lights,…Jun 6, 1992 · N5772C · Substantial damageNTSB MIA92LA130Accident · No injuriesLimited investigationFinal reportCessna 310-R · Summerfield, FLThe failure of the pilot-in-command to switch the fuel selectors in flight which caused both engines to fail due to fuel starvation. Contributing to the accident was the complacency of the pilot-in-command.Jun 6, 1992 · N69HS · Substantial damageNTSB FTW92LA170Accident · No injuriesLimited investigationFinal reportCessna 182D · Beeville, TXEngine power loss for undetermined cause. A factor was the pilots' failure to lower flaps for the short field landing.Jun 6, 1992 · N8979X · Substantial damageNTSB CHI92LA163Accident · No injuriesLimited investigationFinal reportCessna 120 · Elk River, MNThe pilot's improper preflight inspection.Jun 6, 1992 · N76028 · Substantial damageNTSB ATL92LA117Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Williamson, GAThe failure of the pilot of N46RB (the sonerai) to maintain proper runway alignment during the takeoff roll, and his inadequate visual lookout. A factor was the lack of runway edge markings at this airport.Jun 6, 1992 · N6810K · 2 aircraft · Substantial damageNTSB ATL92LA116Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Socastee, SCThe failure of the pilot to maintain proper clearance from terrain during the maneuver. Factors in the accident were the failure of the pilot to release the banner, and the excessive size of the banner.Jun 6, 1992 · N6179Z · DestroyedNTSB NYC92LA100Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Malvern, PAThe pilot abruptly moved the cyclic rearward which resulted in the main rotor blades striking and separating the tail boom. A factor in this accident was the soft muddy field.Jun 5, 1992 · N296Q · Substantial damageNTSB LAX92FA236Accident · 1 fatalField investigationFinal reportCessna 152 · Sylmar, CAThe pilot's failure to adequately judge and evaluate the weather conditions and his improper in-flight decision to fly close to clouds. These acts led to his entering IMC and becoming lost and disoriented.Jun 5, 1992 · N701KA · DestroyedNTSB FTW92LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Truth Or Cons, NMThe pilot's inability to stop due to worn brakes and low brake fluid.Jun 5, 1992 · N4547A · Substantial damageNTSB FTW92LA150Accident · 1 fatalLimited investigationFinal reportLewis-Starduster SA300 · Wills Point, TXThe pilot's inadequate visual lookout.Jun 5, 1992 · N5649 · DestroyedNTSB FTW92LA149Accident · No injuriesLimited investigationFinal reportPiper J3-C-65 · Lake Dallas, TXThe pilot's failure to maintain adequate climb speed which resulted in a stall & subsequent loss of aircraft control. Factors were the crosswind and gusting wind conditions.Jun 5, 1992 · N70494 · Substantial damageNTSB FTW92LA148Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Oil Trough, ARThe pilot's selection of unsuitable terrain for takeoff.Jun 5, 1992 · N8732H · DestroyedNTSB FTW92LA147Accident · No injuriesLimited investigationFinal reportCessna 182 · Coweta, OKThe total loss of engine power for undetermined reasons. Factors were the darkness of the night and the lack of suitable terrain available to the pilot for the forced landing.Jun 5, 1992 · N5381B · Substantial damageNTSB ATL92LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bainbridge, GAThe pilot's misjudged distance of runway remaining, resulting in a delayed decision to abort the takeoff, and subsequent collision with trees. Factors were the high obstructions (trees) at the departure end of the runway.Jun 5, 1992 · N83453 · Substantial damageNTSB LAX92LA234Accident · Serious injuriesLimited investigationFinal reportJacanin Great Lakes · Gila Bend, AZFuel starvation due to the pilot's failure to properly position the fuel selector in the full 'on' setting. A factor in the accident was the design of the fuel selector valve and the location of the temporary radio installation which limited the pilot's view…Jun 4, 1992 · N4045 · DestroyedNTSB FTW92LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Henrietta, TXLoss of engine power from fuel exhaustion and the pilot's failure to refuel the airplane.Jun 4, 1992 · N68735 · Substantial damageNTSB CHI92LA162Accident · Serious injuriesLimited investigationFinal reportCommander C3C · Grain Valley, MOThe jammed (kinked) choke plate control cable, which resulted in reduced power and collision with rising terrain.Jun 4, 1992 · N136E · Substantial damageNTSB SEA92FA116Accident · 3 fatalField investigationFinal reportCessna TR182 · Moxee City, WAThe pilot in command's inadvertently allowing the aircraft to stall. A factor contributing to the accident was: rising terrain.Jun 3, 1992 · N736JG · DestroyedNTSB NYC92LA098Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · New Milford, CTInadequate visual lookout by the pilot which resulted in the glider striking a vehicle parked next to the runway.Jun 3, 1992 · N2724H · Substantial damageNTSB NYC92LA095Accident · Minor injuriesLimited investigationFinal reportBeech N35 · Delaware, OHA loss of control in flight due to wake tubulence from a preceding helicopter. A factor related to the accident was the failure of the pilot to recoginize the hazards of his close proximity behind the landing helicopter.Jun 3, 1992 · N1252Z · Substantial damageNTSB LAX92WA231Accident · Minor injuriesForeign investigationPiper PA-46-310P · Yokota, JapanJun 3, 1992 · N4391B · Substantial damageNTSB LAX92LA233Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Fallbrook, CAThe loss of engine power due to a disconnection of the turbocharger inlet duct.Jun 3, 1992 · N29169 · Substantial damageNTSB LAX92LA232Accident · Serious injuriesLimited investigationFinal reportWayne K. Giles Glasair Garg · Valencia, CAThe loss of engine power because of an undetermined interruption in the flow of fuel to the engine. Factors which contributed to the power loss were related to fuel line or fitting leaks and to inadequate maintenance of the fuel system.Jun 3, 1992 · N555HV · Substantial damageNTSB LAX92LA230Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Redding, CAThe internal failure of the airplane's throttle control cable.Jun 3, 1992 · N8574T · Substantial damageNTSB ANC92LA085Accident · 1 fatalLimited investigationFinal reportTaylorcraft F-19 · Suckling Hills, AKThe pilot failed to maintain airspeed and stalled the airplane. Contributing to the accident was the rising terrain.Jun 3, 1992 · N3550T · Substantial damageNTSB NYC92LA097Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Hazard, KYThe internal failure of the brake's master cylinder. Factors contributing to this accident were; the pilot's improperly planned approach and failure to touch down at the proper point.Jun 2, 1992 · CGDNH · Substantial damageNTSB NYC92LA096Accident · No injuriesLimited investigationFinal reportCessna 140A · Vincentown, NJThe loss of engine power for undetermined reasons resulting in a collision with wires during a forced landing.Jun 2, 1992 · N2939C · Substantial damageNTSB NYC92LA094Accident · No injuriesLimited investigationFinal reportCessna 310R · Cleveland, OHA failure of the left main gear's upper strut housing and down lock link assembly attach point.Jun 2, 1992 · N225SC · Substantial damageNTSB NYC92DHA03Accident · Serious injuriesFinal reportParrish, Paul SKY Bolt · Mehoopany, PAThe pilot inadvertently stalled and spun the airplane at too low an altitude to allow recovery. Contributing to the accident was an engine vibration caused by a broken number 3 exhaust valve. The exhaust valve caused extensive internal damage to the engine.Jun 2, 1992 · N261P · Substantial damageNTSB LAX92LA229Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Las Vegas, NVThe pilot's encounter with a sudden and strong tail wind component during a critical phase of flight which was beyond the capability of the helicopter. A factor in the accident was the confined nature of the helipad with high obstacles and power lines.Jun 2, 1992 · N2301C · Substantial damageNTSB LAX92LA227Accident · No injuriesLimited investigationFinal reportAir Tractor AT 400 · Lemoore, CAThe pilot's failure to observe the presence of an obstacle in the field. Factors which contributed to the accident were the dark nighttime light condition, and the small size and color of the obstacle which decreased the conspicuity of the object.Jun 2, 1992 · N7307V · DestroyedNTSB CHI92FA161Accident · 2 fatalField investigationFinal reportCessna 177B · Almont, MIThe pilot's failure to maintain control of the airplane during takeoff while physically impaired by alcohol.Jun 2, 1992 · N13860 · Destroyed