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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CHI93LA107Accident · No injuriesLimited investigationFinal reportBeech B90 · Chicago, ILThe pilot's misjudging distance from the parked vehicle.NTSB CHI93LA106Accident · Minor injuriesLimited investigationFinal reportBeech A23-19 · Farmington, MOThe pilot's failure to maintain aircraft control.NTSB CHI93IA125Incident · No injuriesIncident investigationFinal reportATR ATR 72 · Chicago, ILthe local controller's failure to issue a proper heading clearance which resulted in a loss of radar separation between two departing airplanes.NTSB ANC93LA041Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Port Alsworth, AKThe non instrument rated pilot in command entering instrument meteorological conditions. A factor in the accident was the snow/whiteout condition.NTSB MIA93IA083Incident · No injuriesIncident investigationFinal reportAero Commander 500 · Everglades City, FLThe preexisting fatigue cracking of the propeller hub arm in the bearing retention radius due to polishing and wear of the radius from contact with the split rings, resulting in a propeller blade separating from the propeller hub on the takeoff ground run,…NTSB MIA93FA082Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Kissimmee, FLThe pilot-in-command's attempt to climb at a high pitch attitude after takeoff and his failure to maintain airspeed which resulted in a stall mush condition until the aircraft descended to the ground. Contributing to the accident was the pilot-in-command's…NTSB LAX93LA143Accident · No injuriesLimited investigationFinal reportE.L. Erickson Tierra II · Rio Linda, CAThe flight's encounter with a downdraft. A factor relating to this accident was the trees.NTSB LAX93LA142Accident · No injuriesLimited investigationFinal reportChampion 7EC · Riverside, CAThe cfi's inadequate supervision of the flight, the dual student's failure to maintain directional control and improper use of the normal brakes. Contributing to this accident was the dual student's improper use of the rudder.NTSB LAX93LA140Accident · Serious injuriesLimited investigationFinal reportBeech C-45H · Oakland, CAA premature lift off and inadvertent stall by the pilot-in-command. Contributing to the accident was insufficient available aircraft performance data after a ferry tank installation and both pilots lack of total experience in the airplane.NTSB LAX93FA141Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Big Bear City, CAA partial loss of takeoff power due to inadequate maintenance and inspection which failed to detect magneto and spark plug deficiencies. In addition, the pilot failed to abort the takeoff after two unsuccessful attempts to get airborne. Factors which…NTSB FTW93LA098Accident · No injuriesLimited investigationFinal reportCessna 177 · Overbrook, OKThe pilot's improper compensation for wind conditions and his failure to recover from a bounced landing. A factor was turbulenceNTSB FTW93LA097Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Plano, TXFuel starvation induced power loss resultant from failure of the pilot to switch the fuel selector to the proper fuel tank. Factors were the dark night conditions and lack of suitable terrain for a forced landingNTSB CHI93LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Lambertville, MIThe student pilot's failure to maintain directional control during the takeoff roll.NTSB CHI93IA115Incident · No injuriesIncident investigationFinal reportde Havilland SHD-6 · Chicago, ILFailure of the approach and local controllers to maintain IFR separation standards between all the airplanes on the approach.NTSB BFO93LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Springboro, OHThe pilot misjudged his distance, and altitude on final approach, and failed to attain the proper touchdown point.NTSB BFO93LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sandusky, OHThe pilot's misjudgement of distance and altitude to the runway, while on final approach, and his failure to attain the proper touchdown point for landing. A factor related to the accident was the proximity of the snowbank to the runway threshold.NTSB BFO93LA045Accident · Serious injuriesLimited investigationFinal reportPitts S-2B · Hillsboro, MDFailure of the pilot to maintain airspeed, while performing aerobatic maneuvers, which resulted in an inadvertent flat spin and an uncontrolled descent into terrain.NTSB BFO93LA044Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Putnam, CTInadequate compliance with applicable air worthiness directives, leaky fuel cap seal, water contamination of the fuel, and wrinkles in the fuel tank bladders that interfered with the ability to drain water from the tanks.NTSB ATL93FA059Accident · 3 fatalField investigationFinal reportCessna 172G · Jackson, GAThe pilots inadequate preflight planning and his failure to properly compensate for the wind. A factor was the unfavorable wind condition at the time of take off.NTSB ANC93LA040Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Iliamna, AKThe pilot in commands attempt to conduct a visual flight during instrument meteorological conditions and his failure to maintain control of the aircraft during the emergency 180 degree turn maneuver to reverse direction. Factors in the accident were the snow…NTSB SEA93LA074Accident · No injuriesLimited investigationFinal reportCessna 150L · Provo, UTDirectional control was not maintained.NTSB MIA93LA081Accident · No injuriesLimited investigationFinal reportRoot, Arthur T. Delta Dyke JD-2 · Sebastian, FLThe pilot-in-command's improper flare and recovery from a bounced landing, resulting in a hard landing which caused landing gear failure. Contributing to the accident was the pilot's lack of total flight time and flight time in the make and model.NTSB LAX93LA139Accident · No injuriesLimited investigationFinal reportAcro Sport Acro Sport · Lake Riverside, CAThat the pilot misjudged the landing/flare altitude. Contributing to this accident was the loss of power for undetermined reasons.NTSB FTW93FA096Accident · 1 fatalField investigationFinal reportCessna 172N · Katy, TXThe pilot's failure to maintain control of the airplane for undetermined reasonsNTSB CHI93LA105Accident · No injuriesLimited investigationFinal reportCessna 172M · Romeo, MIThe pilot's failure to maintain directional control.NTSB CHI93FA103Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Newton, IAVFR flight into IMC conditions. Factors related to the accident were fog, and the pilot's lack of total instrument time.NTSB SEA93IA073Incident · No injuriesIncident investigationFinal reportHughes 269B · Mcminnville, ORAn inflight loss of control, and inadequate remedial action. Factors include a tailwind, and gusts.NTSB MIA93LA080Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Marco, FLThe pilot-in-command's failure to ensure the aircraft contained adequate fuel for the flight, resulting in loss of engine power due to fuel exhaustion.NTSB FTW93LA095Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Midlothian, TXThe loss of engine power and the pilot's failure to refuel. A factor was the inadvertent stall during the flare touchdownNTSB BFO93LA048Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-7-102 · Philadelphia, PAAn encounter with turbulence during final approach. A factor related to the accident was that the flight attendant was not seated with a seat belt fastened.NTSB DCA93IA027Incident · No injuriesIncident investigationFinal reportAerospatiale ATR42-300 · Newark, NJThe flightcrew's failure to follow approved procedures that required a minimum propeller spped while flying in icing condition. Contributing to the loss of roll control were the encounters with severe turbulence and icing conditions.NTSB SEA93LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Riverton, WYThe pilot did not perform an abort of the takeoff after observing a partial loss of power. Factors include improper use of the mixture control.NTSB FTW93LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Houston, TXFuel starvation power loss due to carburetor restriction from a foreign object, the inadequate inspection and improper overhaul of the carburetor by other maintenance personnelNTSB FTW93LA093Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Fort Worth, TXInadvertent stall. A factor was the tailwindNTSB DEN93LA030Accident · No injuriesLimited investigationFinal reportCessna T210N · Walsh, COA complete power loss from mechanical failure. A factor was: a pond, which the aircraft entered during landing roll.NTSB DEN93FA031Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Panama City, FLThe pilot's poorly planned approach to the runway following an instrument approach resulting in a loss of control.NTSB CHI93LA101Accident · No injuriesLimited investigationFinal reportBeech 200 · Chesterfield, MOThe pilot's failure to maintain directional control after encountering whiteout conditions in the landing flare.NTSB BFO93LA042Accident · Minor injuriesLimited investigationFinal reportAsselyn Xenair CH701 · Durham, METhe pilot's inadequate compensation for wind conditions and failure to maintain directional control after lift-off. Factors related to the accident were: the unfavorable wind condition and proximity of the power line.NTSB BFO93LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · New Cumberland, PAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the tailwind and the student pilot's lack of total experience.NTSB BFO93LA039Accident · No injuriesLimited investigationFinal reportCessna 335 · Owensboro, KYFailure of airport personnel to report the runway condition by NOTAM when airport snow removal personnel left snow piled on the edges of the runway. Factors related to the accident were: dark night, fog, and the snowbank.NTSB SEA93FA071Accident · 2 fatalField investigationFinal reportCessna 402B · Oakley, UTPoor inflight planning/decision. Factors to the accident were: dark night condition and terrain clearance was not maintained.NTSB LAX93LA148Accident · 1 fatalLimited investigationFinal reportLangerud Varieze · Zenia, CAThe pilot's poor weather evaluation and continued flight into instrument meteorological conditions. The low ceiling was a factor.NTSB CHI93LA108Accident · No injuriesLimited investigationFinal reportCessna 150M · Aurora, MOThe pilot-in-command's failure to maintain directional control.NTSB CHI93LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Manistique, MIAn excessive taxi speed.NTSB DEN93LA029Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Broomfield, CORudder control interference.NTSB BFO93LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Petersburg, OHLoss of engine power due to undetermined reasons. A factor related to the accident was the short, soft, hilly terrain condition in the emergency landing area.NTSB BFO93LA037Accident · No injuriesLimited investigationFinal reportCessna 182Q · Gettysburg, PAThe pilot's inadequate in-flight decision to land on the snow covered runway that was not currently maintained. Contributing to the pilot's decision was the inadequate report of the runway's condition.NTSB SEA93LA070Accident · No injuriesLimited investigationFinal reportCessna 172M · Salem, ORThe failure of the engine oil pump impeller.NTSB SEA93LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Winnett, MTThe student pilot's failure to maintain directional control. Factors contributing to the accident were the snowbank and lack of total experience in type operation.NTSB MIA93LA079Accident · No injuriesLimited investigationFinal reportAeronca KCA · Bunnell, FLImproper procedures by the other pilot for his failure to perform 's' turns while taxiing.