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 NYC89DFJ01Accident · Minor injuriesFinal reportDavis DA-2A · Skaneateles, NYThe pilot's hard landing which resulted in nose gear collapse.Jun 6, 1989 · N26Q · Substantial damageNTSB 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).Jun 6, 1989 · N29309 · Substantial damageNTSB FTW89LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Bristow, OKThe pilot's improper fuel management and failure of the inflight restart attempt.Jun 6, 1989 · N7959Y · Substantial damageNTSB 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.Jun 6, 1989 · N6693Q · Substantial damageNTSB 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.Jun 6, 1989 · N48749 · Substantial damageNTSB 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.Jun 6, 1989 · N1848U · No damageNTSB CHI89DEV06Accident · No injuriesFinal reportHughes 269C · Millersville, ILLoss of rotor RPM for an undetermined reason during a turn to reverse direction while applying agricultural chemicals.Jun 6, 1989 · N7439F · DestroyedNTSB 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.Jun 6, 1989 · N1003H · Substantial damageNTSB ANC89LA106Accident · No injuriesLimited investigationFinal reportHelio H-295 · King Salmon, AKAn undetermined problem related to the engine, propeller, and/or failed tailwheel assembly.Jun 6, 1989 · N204CW · Substantial damageNTSB 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.Jun 5, 1989 · N8022Q · Substantial damageNTSB CHI89LA103Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Milan, MIThe pilot's excessive rotation, which resulted in an inadvertent mushed stall and collision with trees.Jun 5, 1989 · N5011C · DestroyedNTSB 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…Jun 5, 1989 · N91072 · Substantial damageNTSB ANC89LA085Accident · No injuriesLimited investigationFinal reportCessna 180-J · Glennallen, AKPilot used poor judgement and planning for his takeoff.Jun 5, 1989 · N52010 · Substantial damageNTSB 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…Jun 4, 1989 · N1068J · Substantial damageNTSB SEA89FA099Accident · 2 fatalField investigationFinal reportCushing 4 · Mansfield, WAFailure of the left wing main spar due to overload for undetermined reasons.Jun 4, 1989 · N5321U · DestroyedNTSB 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.Jun 4, 1989 · N373TC · Substantial damageNTSB 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.Jun 4, 1989 · N38329 · Substantial damageNTSB 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.Jun 4, 1989 · N8782G · Substantial damageNTSB MIA89LA170Accident · No injuriesLimited investigationFinal reportCessna 172 · Cedar Key, FLThe pilot's failure to maintain directional control during landing.Jun 4, 1989 · N6013E · Substantial damageNTSB 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.Jun 4, 1989 · N94622 · Substantial damageNTSB 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.Jun 4, 1989 · N9700Q · Substantial damageNTSB 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.Jun 4, 1989 · N4906P · Substantial damageNTSB 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.Jun 4, 1989 · N7545F · Substantial damageNTSB 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…Jun 4, 1989 · N69271 · Substantial damageNTSB 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.Jun 4, 1989 · N3148M · Substantial damageNTSB 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.Jun 3, 1989 · N6061N · Substantial damageNTSB 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.Jun 3, 1989 · N9965D · DestroyedNTSB 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.Jun 3, 1989 · N3952K · Substantial damageNTSB FTW89DPJ05Accident · No injuriesFinal reportNord Stampe SV4C · Bartlesville, OKTotal failure of the engine connecting rod.Jun 3, 1989 · N47SV · Substantial damageNTSB 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.Jun 3, 1989 · N555JW · DestroyedNTSB 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.Jun 3, 1989 · N63452 · Substantial damageNTSB CHI89DET06Accident · No injuriesFinal reportDilley P51R · Hamilton, INThe failure of the #3 connecting rod. A factor was the unsuitable terrain.Jun 3, 1989 · N91KD · Substantial damageNTSB 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.Jun 3, 1989 · N5658J · Substantial damageNTSB 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…Jun 3, 1989 · N6367G · DestroyedNTSB 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.Jun 3, 1989 · N1769 · DestroyedNTSB 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.Jun 3, 1989 · N9642K · Substantial damageNTSB 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.Jun 2, 1989 · N41721 · DestroyedNTSB 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.Jun 2, 1989 · N60812 · Substantial damageNTSB 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.Jun 2, 1989 · N6589Q · DestroyedNTSB 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.Jun 2, 1989 · N3159W · Substantial damageNTSB 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.Jun 2, 1989 · N992PT · Substantial damageNTSB 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.Jun 2, 1989 · N64652 · DestroyedNTSB 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…Jun 2, 1989 · N76KM · DestroyedNTSB CHI89DEX04Accident · Serious injuriesFinal reportNorth American SNJ-5 · Sellersburg, INThe ingestion of a foreign object and subsequent supercharger impeller failure.Jun 2, 1989 · N3665F · Substantial damageNTSB 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.Jun 2, 1989 · N4497Y · Substantial damageNTSB 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.Jun 2, 1989 · N1652G · Substantial damageNTSB 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.Jun 1, 1989 · N5AN · DestroyedNTSB MKC89LA122Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Columbia, MOThe gear-up landing which was made by an unknown/unauthorized person.Jun 1, 1989 · N154P · Substantial damageNTSB 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.Jun 1, 1989 · N987GM · Substantial damageNTSB 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.Jun 1, 1989 · N6822Q · Substantial damage