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 IAD97FA039Accident · 4 fatalField investigationFinal reportAerostar 601P · Chesapeake, VAfailure of the pilot to maintain proper altitude/clearance above the ground after takeoff. A related factor was the pilot's self-induced pressure to depart before the arrival of bad weather.NTSB SEA97FA041Accident · 5 fatalField investigationFinal reportCessna P210N · Cambridge, IDthe pilot's failure to maintain control of the aircraft. Flight into adverse weather and turbulence were factors.NTSB MIA97LA056Accident · Minor injuriesLimited investigationFinal reportCessna 441 · Lakeland, FLFailure of the electronic engine control, which caused an overtorque condition in the right engine that made directional control of the airplane not possible by the pilot when the power to the left engine was retarded to idle during the takeoff roll.NTSB MIA97FA057Accident · 2 fatalField investigationFinal reportCessna 208B · Edenton, NCthe pilot's continued VFR flight into instrument meteorological conditions. Factors in this accident were: fog, the low ceiling, and the dark night.NTSB FTW97LA074Accident · No injuriesLimited investigationFinal reportBeech C90A · Rio Grande City, TXThe pilot's failure to maintain clearance with the tower. Factors were the low ceilings and the pilot's diverted attention to his navigation.NTSB ATL97LA032Accident · No injuriesLimited investigationFinal reportCessna 172N · Anderson, SCThe pilot's improper recovery from a bounced landing. A factor was the pilot's improper level off.NTSB ANC97LA017Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Nome, AKthe pilot's failure to properly verify the position of a fractured fuel selector handle, which resulted in fuel starvation and subsequent loss of engine power. A factor related to the accident was: the fractured handle that allowed the fuel selector to be…NTSB MIA97LA058Accident · No injuriesLimited investigationFinal reportWaco WMF-5 · Kissimmee, FLthe pilot's failure to maintain direction control of the airplane after applying the brakes. A factor was the pilot's lack of familiarity with this make and model airplane.NTSB MIA97LA055Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Florence, SCThe pilot-in-command's improper management of fuel resulting in a total loss of engine power due to fuel exhaustion.NTSB MIA97LA054Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Daytona Beach, FLthe pilot's improper planning/decision, by failing to ensure there was sufficient fuel for continued flight, which resulted in fuel exhaustion and subsequent collision with objects (concrete blocks) during a forced landing. Factors relating to the accident…NTSB IAD97FA038Accident · 1 fatalField investigationFinal reportCessna 150F · Bittinger, MDVFR flight by the noninstrumented-rated pilot into instrument meteorological conditions (IMC), which lead to spatial disorientation of the pilot, his loss of aircraft control, and an uncontrolled collision with the terrain. Factors relating to the accident…NTSB CHI97LA049Accident · No injuriesLimited investigationFinal reportGates Learjet LR35 · Kansas City, MOthe flightcrew's excessive airspeed and failure to attain a proper touchdown point on the runway. Factors were: the fog, wet runway, tailwind and improper procedures by the flight crew.NTSB MIA97LA053Accident · Minor injuriesLimited investigationFinal reportPacheco Searey · Key Biscayne, FLfailure of the pilot to retract the landing gear before landing the amphibious airplane in water. The pilot's lack of experience/certification/training in seaplanes was a possible factor.NTSB MIA97LA052Accident · 1 fatalLimited investigationFinal reportSirocco Flying Club MJ 5 · Sanford, FLfailure of the pilot to maintain adequate airspeed, while maneuvering in the traffic pattern (crosswind) after takeoff, which resulted in an inadvertent stall, uncontrolled descent, and collision with terrain.NTSB MIA97LA051Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Atlanta, GAfailure of the pilot to initiate an immediate climb (go-around or missed approach) after encountering fog, while on final approach to land. Darkness and fog at the end of the runway were related factors.NTSB MIA97IA050Incident · No injuriesIncident investigationFinal reportDouglas DC8-62 · Orlando, FLThe failure of the captain to center the rudder and close all engine throttles during an aborted takeoff resulting in an uncontrolled turn to the right due to nose wheel steering through the rudder pedals and asymmetric engine thrust. A factor in the incident…NTSB LAX97LA081Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Jean, NVThe failure of both pilots to maintain directional control of the aircraft, and the instructor's inadequate supervision of the flight. A factor in the accident was the limited conventional gear experience of both pilots.NTSB LAX97LA080Accident · No injuriesLimited investigationFinal reportCessna 182P · Fullerton, CAFuel system water contamination due to the failure of both pilots to purge all water from the fuel system prior to departure. Contributing factors were: failure of the mechanic conducting the recent annual inspection to identify and replace a deteriorated…NTSB IAD97LA040Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Colombia Staton, OHinadequate supervision by the flight instructor (CFI), and his failure to ensure that sufficient altitude and/or clearance was maintain from obstructions (trees) during the approach. Darkness was a related factor.NTSB FTW97LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Raton, NMfailure of the exhaust rocker arm retaining studs due to over torquing of the attachment bolts by maintenance personnel during installation. A factor was the lack of suitable terrain for the forced landing.NTSB ANC97TA016Accident · No injuriesFinal reportCessna 180 · St Mary'S, AKthe pilot's improper use of carburetor heat, and subsequent loss of engine power. Factors associated with the accident were the presence of ice crystals in the atmosphere, and unsuitable terrain for a forced landing.NTSB ATL97LA031Accident · No injuriesLimited investigationFinal reportCessna 310Q · Selma, ALThe failure of maintenance personnel to correctly repair and install the pilot's seat.NTSB MIA97WA060Accident · No injuriesForeign investigationAerospatiale SA-315B · Sapahwa, PeruNTSB LAX97LA079Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Banning, CAThe pilot's intentional low flight in an area of foothills and canyons at an altitude insufficient to maintain clearance from obstacles.NTSB NYC97LA039Accident · No injuriesLimited investigationFinal reportCessna 150D · Catawba Valley, VAthe pilot's improper planning/decision, and his failure to attain adequate airspeed, which resulted in a stall after takeoff and collision with ground. Factors relating to the accident were: the pilot's use of inadequate terrain for takeoff, high vegetation…NTSB MIA97LA045Accident · No injuriesLimited investigationFinal reportIssoire-Aviation PIK-30 · Boynton Beach, FLfailure of the engine to restart for undetermined reason(s), after gliding (sailing) for about 3 hours, resulting in a forced landing in a swamp.NTSB MIA97FA049Accident · 1 fatalField investigationFinal reportPiper PA-30 · Goldsboro, NCThe pilot's failure to follow instrument approach procedures during numerous instrument approaches and missed approaches which resuled in a total loss of engine power on both engines due to fuel exhaustion. Factors contributing to the accident were: the…NTSB CHI97FA047Accident · Minor injuriesField investigationFinal reportBeech C90 · Rhinelander, WIthe pilot-in-command's inadequate weather evaluation and continued flight into forecast severe icing conditions which exceeded the capabilty of the airplane's anti-ice/deice system. The icing conditions were a factor.NTSB ATL97FA030Accident · 2 fatalField investigationFinal reportBeech A36 · Pensacola, FLThe pilot's mismanagement of the fuel supply that resulted in fuel starvation and the subsequent loss of engine power. A factor was low ceilings.NTSB ATL97FA029Accident · 2 fatalField investigationFinal reportMooney M20C · Roxboro, NCfailure of the pilot to maintain control of the airplane, due to spatial disorientation. Factors relating to the accident were: the pilot's use of an unapproved drug, low ceiling, restricted visibility (fog), and an undetermined anomaly with the vacuum system.NTSB IAD97LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Manville, NJThe pilot's failure to perform a go-around, and his failure to retract the flaps in increments.NTSB CHI97LA048Accident · Minor injuriesLimited investigationFinal reportCessna 402A · Menominee, MIice restricting normal brake system, normal braking not possible for the pilot and the pilot's poor in-flight planning. A factor was the pilot not performing a flight to an alternate destination airport.NTSB MIA97FA047Accident · 2 fatalField investigationFinal reportChampion 7GCBC · Fort Lauderdale, FLIntentional aerobatics at too low an altitude that did not allow for recovery from an intentional maneuver. Contributing to the accident was the operation of the airplane at an overgross weight condition.NTSB FTW97FA073Accident · 2 fatalField investigationFinal reportCessna 210L · Brackettville, TXfailure of the pilot to maintain sufficient altitude and/or clearance from terrain, while on a cross-country flight at night. Factors relating to the accident were: darkness, the prevailing low ceilings, and mountainous/hilly terrain.NTSB CHI97LA046Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Hayes Center, NEinadequate fuel management by the pilot, which resulted in fuel starvation. The factors relating to the accident were: a fuel leak at the engine driven fuel pump, and the engine driven fuel pump pressure was too low.NTSB ATL97LA028Accident · No injuriesLimited investigationFinal reportMooney M20F · Daytona Beach, FLThe pilot's inadequate in-flight fuel consumption calculations, and the excessive flow of the fuel injector servo, that combined to result in fuel exhaustion.NTSB LAX97LA077Accident · No injuriesLimited investigationFinal reportCessna 140 · Emigrant Gap, CAthe pilot's misjudgment of altitude/clearance while attempting a precautionary landing on a closed, snow covered runway.NTSB FTW97LA072Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Austin, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel the airplane. Factors were the lack of suitable terrain for the forced landing and the pilot's improper preflight inspection of the fuel system.NTSB NYC97LA037Accident · 1 fatalLimited investigationFinal reportRichardson Kitfox 4 · Trenton, MEfailure of the pilot to maintain adequate airspeed while maneuvering after takeoff, which resulted in a stall/spin and an uncontrolled descent into terrain. The airplane's excessive gross weight was a related factor.NTSB NYC97FA194Accident · 2 fatalField investigationFinal reportLearjet 35A · Dorchester, NHThe captain's failure to maintain situational awareness, which resulted in the airplane being outside the confines of the instrument approach; and the crew's misinterpretation of a step-down fix passage, which resulted in an early descent into rising terrain.…NTSB MIA97LA048Accident · No injuriesLimited investigationFinal reportKelly Rans S-12 · Jacksonville, FLfailure of the pilot to maintain adequate airspeed, while maneuvering after takeoff, which resulted in a stall/mush and collision with trees.NTSB LAX97LA076Accident · Minor injuriesLimited investigationFinal reportTrickle TR-4 · Davis, CAThe fatigue fracture and separation of one rod end cap bolt. A factor in the accident was the nature of the terrain for the forced landing.NTSB LAX97FA075Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · San Diego, CAThe failure of the pilot-in-command of the Piper PA-28, N943R, to maintain an adequate visual lookout to see and avoid the Cessna 150, N63137. A factor in the accident was the failure of the air traffic controller to issue a traffic advisory to the pilot…NTSB LAX97LA073Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-15 · Las Vegas, NVthe ramp agent's failure to maintain a good situational awareness of the push-back. A factor was the dark night lighting conditions and the general communication failure of the ground push-back crew.NTSB FTW97LA071Accident · No injuriesLimited investigationFinal reportCessna 210A · Peyton, COthe pilot's improper fuel management by failing to avoid a prolong uncoordinated turn or slip, which resulted in fuel starvation. Factors relating to the accident were: darkness, and the lack of (activated) runway lights.NTSB NYC97LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ellington, CTice ingestion into the engine from the carburetor air box, which resulted in a loss of engine power and a subsequent forced landing, off airport, on unprepared terrain.NTSB MIA97WA044Accident · No injuriesForeign investigationPiper PA-23-250 · Walker Cay, BahamasNTSB MIA97LA046Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Mulberry, FLThe pilot's failure to check that the spoiler handle was locked in the retracted position prior to takeoff.NTSB MIA97FA043Accident · 1 fatalField investigationFinal reportForney F-1 · Middleburg, FLVFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), which resulted in spatial disorientation and an uncontrolled descent into a wooded area. Factors relating to the accident were: failure of the pilot to obtain a…NTSB LAX97LA072Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-83 · San Jose, CAThe flight's encounter with severe turbulence while the injured cabin crew was standing.