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 MIA97LA041Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Pensacola, FLfailure of the pilot to maintain directional control during the landing roll, which resulted in a ground swerve and subsequent collapse of the nose gear. The crosswind was a related factor.NTSB FTW97LA061Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Broomfield, COfailure of the pilot to maintain proper alignment with the runway, while landing. A factor relating to the accident was: the variable/gusty wind condition with possible windshear.NTSB ATL97WA024Accident · No injuriesForeign investigationCessna 182 · Bimini, BahamasNTSB FTW97LA058Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B · East Cameron 71failure of the pilot to maintain clearance from an object (crane/bucket). The gusty wind condition and proximity of the crane/bucket were related factors.NTSB ATL97LA023Accident · Minor injuriesLimited investigationFinal reportPereyra Aventura II · Rockledge, FLThe loss of engine power for undetermined reasons.NTSB SEA97FA033Accident · 1 fatalField investigationFinal reportBeech B36TC · Jackson, WYfailure of the pilot to follow IFR procedures. High terrain, low ceiling, icing conditions, and a possible anomaly with the VOR were related factors.NTSB NYC97LA027Accident · No injuriesLimited investigationFinal reportLake LA-4 · Gallipolis, OHthe pilot's improper recovery from a bounced landing, and his failure to maintain directional control, which resulted in a collision with a hangar and parked aircraft. Factors relating to the accident were: the pilot's encounter with rain, sleet, snow, and…NTSB NYC97LA026Accident · 1 fatalLimited investigationFinal reportParker Mustang · Port Norris, NJThe student pilot's failure to maintain adequate airspeed.NTSB MIA97LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNthe student pilot's improper planning/decision, and his failure to maintain proper runway alignment during a crosswind landing. The strong crosswind was a related factor.NTSB LAX97LA078Accident · No injuriesLimited investigationFinal reportCessna TU206G · Mammoth Lakes, CAThe loss of power for undetermined reasons, and the pilot's inappropriate use of flaps and his failure to maintain an adequate airspeed during the subsequent landing attempt.NTSB ATL97LA022Accident · Serious injuriesLimited investigationFinal reportCessna 421C · St. Petersburg, FLimproper installation of the new starter adapter by maintenance personnel.NTSB MIA97FA034Accident · 2 fatalField investigationFinal reportBeech D-45 · Poplarville, MSthe noninstrument-rated pilot's intentional operation of the airplane with known deficiencies in equipment (inoperative attitude indicator and directional gyro) with an estimated time of arrival after official twilight. Also, poor in-flight planning decision…NTSB LAX97WA094Accident · No injuriesForeign investigationCessna 182N · Obergon, MexicoNTSB LAX97FA067Accident · 1 fatalField investigationFinal reportBeech V35B · Lake Tahoe, CAthe pilot's intentional flight into adverse weather and improper in-flight planning and decision making.NTSB LAX97FA066Accident · Serious injuriesField investigationFinal reportBeech 95-C55 · Riverside, CAfuel starvation due to improper fuel management. Contributing to the accident was the pilot's preoccupation of discussing the legality of the approach with the tower controller, and fatigue.NTSB IAD97LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Elyria, OHThe pilot's fuel mismanagement which led to fuel starvation to one engine, and the pilot's failure to maintain control of the airplane.NTSB FTW97LA056Accident · No injuriesLimited investigationFinal reportBeech A23 · Conway, ARthe pilot's inadequate compensation for the crosswind during the landing, and his failure to remain clear of the tree during the attempted go-around. The crosswind and the proximity of the small tree were related factors.NTSB ATL97FA092Accident · 2 fatalField investigationFinal reportCessna 182 · Charleston, SCThe noninstrument-rated pilot's failure to remain clear of instrument meteorological conditions which led to spatial disorientation and loss of aircraft control. A factor was the pilot's failure to obtain a weather briefing.NTSB MIA97LA035Accident · No injuriesLimited investigationFinal reportHoster/Volmer VJ22 (Sportsman) · Seminole, FLinadequate maintenance/inspection of the airplane by the pilot/owner, and fuel contamination that resulted in fuel starvation.NTSB MIA97FA031Accident · 1 fatalField investigationFinal reportPiper PA32-300D · Reform, ALa complete loss of engine power due to a total failure of both magnetos, and the failure of the pilot-in-command to insure that the airplane was airworthy. The dark night and unsuitable terrain were factors.NTSB CHI97WA039Accident · 2 fatalForeign investigationLearjet 36 · Stephenville, IrelandNTSB CHI97LA040Accident · No injuriesLimited investigationFinal reportBeech B55 · Park Rapids, MNthe pilot's high flare. Factors were the icing weather condition and the airframe ice.NTSB ANC97IA011Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Anchorage, AKThe ground crew's failure to maintain communication with the flight crew while loading cargo after pushback and engine start, and the ground and flightcrew's failure to follow the procedure outlined in their manuals concerning use of marshallers during…NTSB SEA97LA036Accident · 2 fatalLimited investigationFinal reportPiper PA18-135 · Cohagen, MTThe pilot's failure to maintain airspeed. Factors were the intentional flight at a low altitude and the over gross condition of the airplane.NTSB LAX97FA065Accident · 2 fatalField investigationFinal reportOpperman Lancair IV-P · Suisun City, CAIn-flight loss of control for an undetermined reason.NTSB DCA97WA013Incident · No injuriesForeign investigationBoeing 747-236F · Hong Kong, United KingdomNTSB ANC97LA012Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Nunapitchuk, AKthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing. Factors associated with the accident were: the low fuel condition, which led to a single engine landing, and the crosswind condition.NTSB IAD97LA028Accident · No injuriesLimited investigationFinal reportHughes 269C · Mayfield, KYdisengagement of the main transmission aft pinion nut, allowing the tail rotor splined drive sleeve to disengage from the pinion, which resulted in loss of directional control and an emergency (autorotative) landing.NTSB IAD97LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Claverack, NYloss of engine power for undetermined reasons.NTSB CHI97LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · New Hudson, MIloss of engine power for undetermined reason(s). Darkness was a related factor.NTSB ANC97LA010Accident · No injuriesLimited investigationFinal reportCessna 172M · Bethel, AKthe pilot's improper planning/decision, and resultant failure to obtain/maintain sufficient airspeed during takeoff. A factor related the accident was: taking off with a tailwind.NTSB NYC97FA025Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Felton, PAThe pilot's inadequate preflight planning and preparation, and his failure to refuel which resulted in fuel exhaustion and the subsequent collision with trees during the forced landing.NTSB MIA97LA033Accident · No injuriesLimited investigationFinal reportCessna 150H · Homerville, GAcarburetor ice, due to the pilot's improper use of carburetor heat, which resulted in a forced landing and impact with trees.NTSB CHI97LA036Accident · No injuriesLimited investigationFinal reportCessna 177 · Regan, NDthe pilot's intentional flight into adverse weather. Factors were clouds, the pilot's inadequate in-flight planning/decision making, his poor evaluation of the weather, and the encounter with unsuitable terrain for landing.NTSB NYC97LA024Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Myerstown, PAfatigue failure of the connecting rod to crankshaft attachments, due to inadequate overhaul of the engine by the manufacturer, which resulted in a loss of engine power and a forced landing. Factors relating to the accident included the discharge of oil from…NTSB FTW97LA054Accident · No injuriesLimited investigationFinal reportLet L23 · Bryan, TXthe pilot misjudged his distance and altitude during the landing approach. Factors relating to the accident were: the high obstructions (power lines), and subsequent tailwind during the forced landing.NTSB MIA97LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Sugarloaf Key, FLa complete loss of engine power due to a disconnected connecting rod cap.NTSB LAX97LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Tusayan, AZFuel exhaustion due to the pilot's inadequate preflight planning and his miscalculation of the fuel required for the flight.NTSB FTW97LA053Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Ruidoso, NMfailure of the pilot to maintain directional control during landing roll, and his delayed aborted landing. The gusty crosswind and blown left main tire were considered to be related factors.NTSB ATL97FA021Accident · 3 fatalField investigationFinal reportBellanca 17-31ATC · Fitzgerald, GAA loss of engine power due to the blockage of the intake manifold of the induction air system, by the broken alternate air door, and the loss of aircraft control for undetermined reasons.NTSB NYC97LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Long Pond, PAThe pilot's inadequate preflight planning/preparation and improper inflight planning/decision, which resulted in fuel exhaustion and the loss of engine power, due to an inadequate supply of fuel. Darkness and trees in the emergency landing area were related…NTSB LAX97LA058Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Scottsdale, AZdetonation/pre-ignition for unknown reason(s), which resulted in failure of the number two piston, loss of engine power, and a subsequent forced landing on rough/uneven desert terrain.NTSB LAX97IA056Incident · Minor injuriesIncident investigationFinal reportEmbraer EMB-120ER · Los Angeles, CAa laser light source of unknown origin, directed toward the aircraft, as it was approaching to land.NTSB LAX97FA059Accident · 3 fatalField investigationFinal reportMorane-Saulnier MS760 II · Irvine, CAThe pilot's failure to maintain an adequate airspeed margin while maneuvering in a steep banked turn to the landing runway, which resulted in an inadvertent stall/spin. Factors in the accident were: the pilot's inadequate preflight inspection of the aircraft…NTSB IAD97FA025Accident · 1 fatalField investigationFinal reportAero Commander 681 · Mansfield, OHthe pilot's early descent below the minimum descent altitude (MDA), while preparing to land from an instrument approach, and his failure to maintain adequate altitude and clearance from obstruction(s).NTSB ANC97FA009Accident · 2 fatalField investigationFinal reportCessna 185 · Marshall, AKfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall and collision with the terrain.NTSB LAX97LA064Accident · No injuriesLimited investigationFinal reportCessna 172 · Big Bear City, CAthe pilot's inadequate compensation for the wind condition, and his failure to maintain alignment with the runway. The gusty crosswind was a related factor.NTSB LAX97LA057Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mcgregor Point, HIthe pilot's failure to maintain control of the aircraft and distance from the pole.NTSB IAD97LA026Accident · Serious injuriesLimited investigationFinal reportCessna 205 · Columbia, PAThe pilot's failure to obtain/maintain airspeed, which resulted in an inadvertent stall, and collision with trees during the initial climb. A factor in the accident was a tailwind condition.NTSB IAD97FA024Accident · Serious injuriesField investigationFinal reportCessna 182P · Fort Washington, MDLoss of engine power for undetermined reason(s).