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 NYC89DFJ01Accident · Minor injuriesFinal reportDavis DA-2A · Skaneateles, NYThe pilot's hard landing which resulted in nose gear collapse.NTSB MKC89LA128Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Creve Coeur, MOImproper use of the carburetor heat by the pilot and carburetor ice. Contributing factors were: carburetor icing conditions, high obstructions and terrain conditions (corn crop).NTSB FTW89LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Bristow, OKThe pilot's improper fuel management and failure of the inflight restart attempt.NTSB FTW89DRD06Accident · No injuriesFinal reportGrumman-Schweizer G-164B · Ville Platte, LAWear and/or failure of the carburetor/float. Factors related to the accident were: the terrain conditions.NTSB DEN89LA134Accident · Serious injuriesLimited investigationFinal reportRyan ST-3KR · La Salle, COForeign material (insect nest) blocking the fuel system vent, which resulted in a restriction of fuel flow and fuel starvation. A related factor was the alfalfa crop in the emergency landing area.NTSB CHI89IA104Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10 · Garden City, KSThe failure of some of the passengers to follow the captain's instructions to fasten their lap belts.NTSB CHI89DEV06Accident · No injuriesFinal reportHughes 269C · Millersville, ILLoss of rotor RPM for an undetermined reason during a turn to reverse direction while applying agricultural chemicals.NTSB CHI89DEM02Accident · Minor injuriesFinal reportAeronca 15AC · Plainwell, MIThe pilot's decision to fly the airplane which had not been properly maintained which resulted in the fuel system blockage.NTSB ANC89LA106Accident · No injuriesLimited investigationFinal reportHelio H-295 · King Salmon, AKAn undetermined problem related to the engine, propeller, and/or failed tailwheel assembly.NTSB SEA89LA100Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Prineville, ORThe pilots inadequate visual lookout and failure to maintain clearance from obstructions, resulting in the tail rotor impacting a road sign and subsequent loss of anti-torque control.NTSB CHI89LA103Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Milan, MIThe pilot's excessive rotation, which resulted in an inadvertent mushed stall and collision with trees.NTSB BFO89LA042Accident · No injuriesLimited investigationFinal reportBeech T-34B · Suffolk, VAAn inadvertent stall due to failure of the student pilot to obtain adequate flying speed and inadequate supervision by the instructor pilot (CFI). The inoperative stall warning system was considered to be a contributing factor. The intermittent intercomm…NTSB ANC89LA085Accident · No injuriesLimited investigationFinal reportCessna 180-J · Glennallen, AKPilot used poor judgement and planning for his takeoff.NTSB SEA89LA097Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Boulder City, NVPoor judgement of the pilot by flying, while impaired from consumption of alcohol, and his delay in initiating a go-around when the aircraft drifted to the right of the runway. Related factors were: light conditions at dusk, unfavorable winds, and failure of…NTSB SEA89FA099Accident · 2 fatalField investigationFinal reportCushing 4 · Mansfield, WAFailure of the left wing main spar due to overload for undetermined reasons.NTSB MKC89LA126Accident · Serious injuriesLimited investigationFinal reportOlson BD-4 · Cedar Rapids, IAPremature lift-off and inadvertent stall by the pilot. A loss of directional control and an inadvertent ground swerve by the pilot were contributing factors.NTSB MKC89LA124Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Buffalo, MNMisjudgement of altitude and distance by the student and inadequate supervision of flight by the instructor (CFI). Contributing factors were: unfavorable wind conditions, high vegetation (grass), and a ditch.NTSB MIA89LA171Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Picayune, MSInadequate preflight by the pilot and his miscalculation of fuel, which resulted in fuel starvation from lack of fuel; and the pilot's failure to see-and-avoid the power lines during the forced landing. The power lines were a contributing factor.NTSB MIA89LA170Accident · No injuriesLimited investigationFinal reportCessna 172 · Cedar Key, FLThe pilot's failure to maintain directional control during landing.NTSB MIA89LA169Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLThe pilot's late flare which resulted in a hard landing that exceeded the design stress limits of the airplane.NTSB MIA89LA168Accident · No injuriesLimited investigationFinal reportBeech A24R · Gulfport, MSFailure of a #2 connecting rod assembly, which resulted in separation of the #2 cylinder and subsequent loss of engine power. Contributing factors were: inadequate maintenance, the transmission (power) line, and trees.NTSB FTW89LA108Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fort Worth, TXInitially the loss of power on the left engine due to an inadequate preflight by the pilot. A secondary cause was a inadvertent feathering of the wrong propeller by the pilot.NTSB DEN89LA132Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Monticello, UTInadequate preflight of the aircraft by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. The terrain condition was considered to be a factor.NTSB BFO89LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Dover Afb, DEThe pilot's improper flare, improper recovery from a bounced landing, and his delay in initiating a go-around, which resulted in an uncontrolled porpoise, loss of directional control, and an uncontrolled ground swerve. His lack of experience, a crosswind, and…NTSB ANC89LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Anaktuvuk Pass, AKThe pilot failed to adequately compensate for downdrafts encountered after departing a gravel bar that was surrounded by mountainous terrain.NTSB SEA89LA102Accident · No injuriesLimited investigationFinal reportBeech 19A · Cashmere, WAThe pilot used poor starting procedures. The airplane was inadequately secured resulting in a collision with an object when the airplane broke free of the tiedown ropes.NTSB NYC89LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA22-150 · Uxbridge, MAImproper maneuvering shortly after takeoff from a private grass strip of marginal length for the caliber of acft being operated. A wind change added to the already exacting conditions.NTSB MKC89LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bolivar, MOImproper planning/decision by the pilot and his delay in aborting the takeoff. Contributing factors were the tall grass, inadequate runway maintenance, and trees.NTSB FTW89DPJ05Accident · No injuriesFinal reportNord Stampe SV4C · Bartlesville, OKTotal failure of the engine connecting rod.NTSB DEN89FA131Accident · 1 fatalField investigationFinal reportBoeing PT-17 · Meeker, COThe inadvertent stall-spin at an altitude insufficient to effect a safe recovery. Contributing factors include high density altitude and wind shear.NTSB CHI89LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Ansonia, OHFlight into known adverse weather by the student pilot, and his inadvertent descent into the terrain. The adverse weather condition was a related factor.NTSB CHI89DET06Accident · No injuriesFinal reportDilley P51R · Hamilton, INThe failure of the #3 connecting rod. A factor was the unsuitable terrain.NTSB CHI89DEM01Accident · Serious injuriesFinal reportCessna 188A · Belding, MIThe pilot's poor preflight assessment of the runway condition/aircraft performance capabilities, and the aircraft's resultant failure to attain flying speed. Soft terrain is a factor in the accident.NTSB ATL89FA157Accident · 1 fatalField investigationFinal reportCessna 150K · N. Myrtle Beach, SCThe pilot's confusion and diverted attention regarding the multiple banner release system in the cockpit resulting in an inadvertent stall/spin into the terrain from a low altitude. Also causal was the pilot attempting the abrupt maneuver at the low airspeed…NTSB ATL89DMG05Accident · 1 fatalFinal reportBloodworth Pitts Special S-1C · Townsville, NCInadequate altitude for the pilot to recover from a spin. A contributing factor was his ostentatious display.NTSB ANC89FA084Accident · 1 fatalField investigationFinal reportStinson 108-2 · Wasilla, AKPilot failed to operate the aircraft within its recommended parameters, resulting in loss of control and a stall-spin into the water.NTSB SEA89LA098Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Buena, WAThe pilot's failure to maintain an adequate visual lookout and clearance to avoid the power lines.NTSB NYC89LA145Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Erwinna, PALoss control and collision with trees due to failure of the student pilot to compensate for the wind and lack of supervision by the CFI.NTSB NYC89LA144Accident · Minor injuriesLimited investigationFinal reportAlon Aircoupe A-2 · Cattaraugus, NYEngine power loss due to fuel starvation resulting from the installation of an improper fuel pump. A factor related to the accident was: trees in the emergency landing area.NTSB MKC89LA123Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Poplar Bluff, MOThe pilot in command misjudged the clearance of the aircraft's vertical stabilizer from the power lines.NTSB FTW89LA106Accident · No injuriesLimited investigationFinal reportBell 206L · Abbeville, LAPartial loss of engine power for an undetermined reason. Factors related to the accident were: person(s) in the intended emergency landing area and soft terrain where the helicopter touched down.NTSB FTW89FA107Accident · Serious injuriesField investigationFinal reportPitts S-1S · Henryetta, OKAn engine power loss due to the separation and departure of an exhaust stack. The stack failed due to poor weld. Factor(s) was: the terrain conditions of the selected forced landing site.NTSB DEN89MA130Accident · 4 fatalMajor investigationFinal reportBell 206L-3 · Big Timber, MTFailure of the pilot to maintain control of the aircraft during takeoff, due to spatial disorientation, which resulted in a collision with the terrain. Contributing factors were: dark night, pilot's visual perception, inadequate initial training of the pilot…NTSB CHI89DEX04Accident · Serious injuriesFinal reportNorth American SNJ-5 · Sellersburg, INThe ingestion of a foreign object and subsequent supercharger impeller failure.NTSB BFO89DIG01Accident · Minor injuriesFinal reportPiper PA-25-235 · Preston, MDPilot's failure to maintain adequate clearance with the wheat crop as he passed under the powerline during an aerial application swath run.NTSB ATL89LA156Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Myrtle Beach, SCThe improper installation/modification of the banner tow system, which jammed the rudder during a landing. The wind and terrain conditions were related factors.NTSB NYC89LA143Accident · No injuriesLimited investigationFinal reportBeech 60 · Philadelphia, PAImproper flare by the pilot during the landing, and his failure to maintain directional control of the aircraft.NTSB MKC89LA122Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Columbia, MOThe gear-up landing which was made by an unknown/unauthorized person.NTSB LAX89LA210Accident · No injuriesLimited investigationFinal reportBeech E-90 · Tuba City, AZThat ground personnel did not properly clear the runway of animals prior to reporting to the pilot that it was clear to land.NTSB FTW89DRA06Accident · No injuriesFinal reportGrumman G-164B · Lissie, TXA bird strike which resulted in foreign object damage to the engine compressor. A berm and the lack of suitable terrain for a forced landing were contributing factors.