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 FTW95LA351Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Abilene, TXThe pilot's inadvertent stall as result of an abrupt maneuver. A factor was the loss of engine power for undetermined reasons.Aug 19, 1995 · N57527 · Substantial damageNTSB CHI95LA299Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Tribune, KSthe pilot's use of excessive braking during the landing roll. A factor associated with the accident was the pilot's failure to maintain directional control of the airplane during the landing roll.Aug 19, 1995 · N6911M · Substantial damageNTSB CHI95LA288Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-1 · Hammond, WIan overload failure of the right horizontal support tube assembly which the pilot/owner had modified to be adjustable. A factor in the accident was the corn.Aug 19, 1995 · N320WM · DestroyedNTSB BFO95FA082Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · East Moriches, NYthe structural failure of the wing for undetermined reasons.Aug 19, 1995 · N86587 · DestroyedNTSB ATL95LA164Accident · No injuriesLimited investigationFinal reportCessna 188B · Raeford, NCthe loss of the abutment seal which resulted in the fatigue failure of the cylinder head.Aug 19, 1995 · N731VX · Substantial damageNTSB ATL95LA161Accident · Serious injuriesLimited investigationFinal reportRonsrans R 12 · Clanton, ALThe pilot's failure to maintain proper flying speed, and the improper mixture of the fuel.Aug 19, 1995 · N800RK · Substantial damageNTSB SEA95LA194Accident · No injuriesLimited investigationFinal reportCessna 421 · Creswell, ORthe company mechanic's failure to properly fabricate a fuel line.Aug 18, 1995 · N3121K · Substantial damageNTSB SEA95LA186Accident · No injuriesLimited investigationFinal reportBeech P-35 · Bend, ORseizure of the #4 connecting rod bearing due to overtemperature resulting in the separation of the connecting rod and total loss of engine power. A factor contributing to the accident was the lack of suitable terrain for a forced landing.Aug 18, 1995 · N9531Y · Substantial damageNTSB NYC95LA198Accident · Minor injuriesLimited investigationFinal reportBell 206B · Bingham, MEthe pilot's inadequate landing flare resulting in a hard landing and roll over, and a subsequent collision with trees.Aug 18, 1995 · N16915 · DestroyedNTSB LAX95LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Gilbert, AZThe pilot's fuel system mismanagement and improper emergency procedure. The pilot's misjudging the flare was a factor.Aug 18, 1995 · N502MP · Substantial damageNTSB FTW95LA350Accident · No injuriesLimited investigationFinal reportCessna A150L · Paragould, ARLoss of engine power due to an undetermined reason. A factor relating to the accident was: the lack of suitable terrain for the forced landing.Aug 18, 1995 · N6041J · Substantial damageNTSB FTW95IA348Incident · No injuriesIncident investigationFinal reportBoeing 737-3H4 · Lubbock, TXinstallation of an incorrect bearing in the number three main wheel by the wheel assembly supplier, which led to subsequent failure of the wheel bearing and separation of the wheel during takeoff.Aug 18, 1995 · N309SW · Minor damageNTSB CHI95IA286Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE Jetstream 3201 · Champaign, ILfatigue cracking and subsequent catastrophic failure of the number two engine helical drive (bull) gear, which resulted in an overtemperature condition, bursting of the combustion plenum, and a subsequent in-flight fire.Aug 18, 1995 · N425AM · Minor damageNTSB CHI95FA285Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Ardoch, NDthe pilot-in-command's continuing flight into adverse weather. Factors were the pilot-in-command's failure to obtain a weather observation and the adverse weather.Aug 18, 1995 · N85115 · DestroyedNTSB ANC95LA144Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe pilot's inadequate visual lookout for obstacles. The low light condition at dusk was a related factor.Aug 18, 1995 · N756YJ · Substantial damageNTSB ANC95LA143Accident · Serious injuriesLimited investigationFinal reportWaco UPF-7 · Anchorage, AKThe pilot's inadequate preflight planning/preparation, which resulted in an unlocked engine primer and subsequent loss of engine power.Aug 18, 1995 · N134Q · Substantial damageNTSB ANC95FA157Accident · 1 fatalField investigationFinal reportPiper L-21A · Kaktovik, AKThe pilot's failure to maintain adequate altitude/clearance from mountainous terrain.Aug 18, 1995 · N8373H · DestroyedNTSB NYC95LA197Accident · No injuriesLimited investigationFinal reportSaab-Scania SF-340-A · Philadelphia, PAthe failure of a titanium hydraulic line, which resulted in an uncontained hydraulic fluid wing fire. A factor was the use of a procedure by the operator, approved by the FAA, but not approved by the airplane manufacturer, which resulted in compartment…Aug 17, 1995 · N742BA · Substantial damageNTSB LAX95LA298Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas 500 · Pacific Ocean (Pacific Ocean)the accidental discharge of a spear gun by the observer.Aug 17, 1995 · N9213F · Substantial damageNTSB LAX95FA297Accident · 2 fatalField investigationFinal reportBeech D55 · Kingsburg, CAthe failure of the pilot to maintain sufficient airspeed during a simulated engine failure to avoid an inadvertent stall/spin, and inadequate supervision by the designated pilot examiner. A factor in the accident was the decision of the examiner to use an…Aug 17, 1995 · N4884J · DestroyedNTSB ATL95FA159Accident · 1 fatalField investigationFinal reportWSK PZL Mielec M-26 · Jonesborough, TNa blocked fuel injector nozzle, which increased the engine fuel consumption; failure of the pilot to adequately monitor fuel consumption, which resulted in fuel exhaustion before the airplane reached the destination; and the passenger's interference with the…Aug 17, 1995 · N7080L · Substantial damageNTSB ANC95LA153Accident · No injuriesLimited investigationFinal reportCessna 180 · Nikiski, AKThe pilot's selection of unsuitable terrain for landing. Soft terrain and contamination in the left brake cylinder were related factors.Aug 17, 1995 · N9797G · Substantial damageNTSB ANC95LA145Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Skwentna, AKThe pilot's improper planning/decision. A factor relating to the accident was: the pilot's selection of a short/uneven landing area that required excessive braking action while landing with a tailwind.Aug 17, 1995 · N9067D · Substantial damageNTSB NYC95LA196Accident · Serious injuriesLimited investigationFinal reportCessna 150 · North East, PAThe student pilot's delay in initiating an aborted landing and his failure to attain obstacle clearance.Aug 16, 1995 · N5774E · Substantial damageNTSB NYC95LA194Accident · 2 fatalLimited investigationFinal reportGreat Lakes 2T1-A2 · Fombell, PAthe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed.Aug 16, 1995 · N49CR · DestroyedNTSB NYC95FA195Accident · 2 fatalField investigationFinal reportCessna 310R · Altoona, PApropagation of corrosion cracks in the right engine overboard exhaust stack and fatigue failure of the exhaust stack, which resulted in escape of hot/high velocity gases, in-flight fire, emergency descent, and subsequent collision with trees during an…Aug 16, 1995 · N2640L · DestroyedNTSB MIA95LA206Accident · Minor injuriesLimited investigationFinal reportBeech 65 · Caribbean SeaLoss of engine power for undetermined reasons. Contributing to the accident was the inability of the pilot to feather the propeller.Aug 16, 1995 · N5078C · DestroyedNTSB LAX95LA296Accident · No injuriesLimited investigationFinal reportCessna 172P · Hesperia, CAThe failure of the connecting rod due to the rod bolt backing off, and the pilot's misjudging the distance and altitude.Aug 16, 1995 · N5462K · Substantial damageNTSB FTW95LA346Accident · No injuriesLimited investigationFinal reportCessna 150F · Manila, ARA blown (tripped) fuse, which rendered flap retraction inoperative. Factors relating to the accident were: the hot weather condition, the aircraft's lack of climb performance with the flaps extended, and the lack of suitable terrain in the forced landing area.Aug 16, 1995 · N8905S · Substantial damageNTSB FTW95LA345Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Wilmot, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Aug 16, 1995 · N2065S · Substantial damageNTSB CHI95LA282Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Mount Vernon, MOloss of aircraft control for an undetermined reason.Aug 16, 1995 · N83564 · Substantial damageNTSB CHI95LA281Accident · No injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILinadequate preflight planning and preparation by the pilot and an inadverent stall encountered by the pilot.Aug 16, 1995 · N6146E · Substantial damageNTSB CHI95LA280Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Champaign, ILthe pilot's failure to maintain directional control of the airplane during takeoff.Aug 16, 1995 · N381AV · Substantial damageNTSB ATL95LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bolivar, TNThe student pilot's failure to maintain directional control and his improper use of the throttle.Aug 16, 1995 · N44784 · Substantial damageNTSB ANC95LA142Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Glennallen, AKThe pilot's selection of unsuitable terrain for takeoff. High vegetation and upsloping terrain were related factors.Aug 16, 1995 · N1484H · Substantial damageNTSB SEA95LA184Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Owyhee, ORThe pilot's failure to maintain directional control. A factor contributing to the accident was his diversion of attention.Aug 15, 1995 · N6854P · Substantial damageNTSB MIA95LA205Accident · No injuriesLimited investigationFinal reportBell 206B · Immokalee, FLThe pilot's improper use of the cyclic during a power-on autorotative landing (low flare), resulting in the ventral fin colliding with the ground.Aug 15, 1995 · N193JB · Substantial damageNTSB LAX95LA295Accident · No injuriesLimited investigationFinal reportCessna 172F · Bradley, CAfuel exhaustion due to the pilot's failure to refuel prior to takeoff and his delayed decision to proceed to his alternate airport. The night light conditions and the lack of a suitable emergency landing area were factors.Aug 15, 1995 · N5563R · Substantial damageNTSB FTW95TA390Accident · Minor injuriesFinal reportPiper PA-18-150 · Brackettville, TXThe pilot's improper compensation for wind conditions, and failure to maintain directional control. A factor relating to the accident was: the variable crosswind.Aug 15, 1995 · N2357Z · Substantial damageNTSB CHI95LA289Accident · No injuriesLimited investigationFinal reportBeech B-60 · Salina, KSthe pilot's inattentiveness to the severity of the weather conditions, and his failure to maintain airspeed. Factors in the accident were: the icing conditions, airframe ice accumulation, and the design stress limits of the airplane being exceeded by the…Aug 15, 1995 · N999AB · Substantial damageNTSB CHI95LA278Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-400 · Hayti, MOthe pilot inadvertently stalled the airplane. A factor was the reduced power setting.Aug 15, 1995 · N2315Z · DestroyedNTSB BFO95LA081Accident · No injuriesLimited investigationFinal reportBeech 55 · Mansfield, OHthe inflight and postimpact fire due to a short circuit in the main power distribution cable.Aug 15, 1995 · N1685W · DestroyedNTSB ANC95LA140Accident · No injuriesLimited investigationFinal reportCessna 185A · Teller, AKDeflation of the left main tundra tire due to valve stem damage (failure) when the tire rotated independently of the wheel rim, resulting in loss of directional control and a ground swerve.Aug 15, 1995 · N4145Y · Substantial damageNTSB ANC95LA139Accident · Serious injuriesLimited investigationFinal reportMaule MA-4 · Port Alsworth, AKThe pilot's improper planning/decision and failure to attain sufficient airspeed to sustain a climb before hitting trees. The unfavorable wind condition was a related factor.Aug 15, 1995 · N4741T · Substantial damageNTSB SEA95LA183Accident · Minor injuriesLimited investigationFinal reportBeech V35A · Chimacum, WAthe improper top overhaul of the engine and subsequent release of the cylinder hold-down nuts/breakage of hold-down and through-bolts. Factors contributing to the accident were the fence posts and rough/uneven terrain.Aug 14, 1995 · N8469N · Substantial damageNTSB NYC95LA193Accident · No injuriesLimited investigationFinal reportCessna 172 · Fulton, NYthe pilot misjudged the flare, resulting in a hard landing and subsequent collapse of the nose gear.Aug 14, 1995 · N6338F · Substantial damageNTSB NYC95LA191Accident · No injuriesLimited investigationFinal reportBeech 23 · Spafford, NYthe loss of engine power for undetermined reasons resulting in a forced landing over unsuitable terrain and the subsequent collision with trees.Aug 14, 1995 · N4798J · Substantial damageNTSB NYC95IA192Incident · No injuriesIncident investigationFinal reportBoeing 747-130 · Jamaica, NYfailure and separation of the #1 engine turbine shroud assembly, which resulted in an uncontained engine failure, a puncture of the #2 outboard reserve fuel tank plate, and a fuel leak.Aug 14, 1995 · N603FF · Minor damageNTSB NYC95FA188Accident · 1 fatalField investigationFinal reportBeech 58 · Mapleton, METhe pilot inadvertently shut down the right engine and feathered the propeller after a loss of power in the left engine, and he failed to maintain adequate airspeed, which resulted in an inadvertent stall/spin and collision with the ground. A factor relating…Aug 14, 1995 · N168CG · DestroyedNTSB LAX95LA294Accident · No injuriesLimited investigationFinal reportThorp T18 · Sedona, AZthe pilot's loss of directional control in gusty tail wind conditions during the landing roll.Aug 14, 1995 · N8032Q · Substantial damage