NTSB investigations, 1990
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 WHERE year(c.\"eventDate\") = 1990 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 WHERE year(c."eventDate") = 1990 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 ATL90FA183Accident · 2 fatalField investigationFinal reportGrumman AA5B · Gallatin, TNThe pilot's failure to maintain the proper altitude which resulted in the inadvertent descent into the ground, and his diverted attention to another airplane. Factors in the accident were fog, dark night, fatigue from lack of sleep, and a lack of recent night…NTSB ANC90LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Anchorage, AKThe pilot's poor judgement due to consumption of alcohol, and his improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB SEA90LA199Accident · 2 fatalLimited investigationFinal reportCessna 172N · Neilton, WAThe failure of the crew to maintain adequate clearance from the terrain. Factors to the accident were mountainous and box canyon terrain.NTSB SEA90LA198Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Albany, ORThe pilot's decision to land with a strong tailwind resulted in the collapse of the landing gear.NTSB NYC90FA231Accident · 2 fatalField investigationFinal reportCessna 182Q · Nantucket, MAThe pilot's improper IFR operation in attempting an ILS approach in an airplane not equipped with an ILS glide slope receiver. The weather conditions were factors in the accident.NTSB NYC90DNA05Accident · 2 fatalFinal reportNorth American P-51D · Chatham, MAThe pilot's failure to maintain flying speed which resulted in an accelerated stall and loss of airplane control.NTSB LAX90LA340Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 9 · Vacaville, CAThe Balloon's encounter with a sudden increase in wind speed accompained by a strong down draft beyond the compensation capability of the Balloon.NTSB LAX90LA338Accident · Serious injuriesLimited investigationFinal reportMooney M-20-M · Flagstaff, AZEngine failure due to a ruptured fuel pump diaphragm. A factor in the accident was the unsuitable nature of the terrain to make a forced landing.NTSB LAX90LA330Accident · No injuriesLimited investigationFinal reportRepublic RC3 · Lakeport, CAThe pilot's failure to maintain control of the aircraft while high-speed water taxiing. The excessive taxi speed is considered a factor in the accident.NTSB LAX90FA336Accident · 8 fatalField investigationFinal reportLockheed PV-2 · Lakeport, CAThe pilot-in-command's failure to maintain airspeed during a pull-up from a low pass. Factors which contributed to the accident were: the pilot's poor judgement in buzzing the seaplanes which resulted in insufficient altitude to recover from the stall, and…NTSB FTW90LA188Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Albany, TXFuel starvation power loss due to the inadvertent movement of the fuel selector valve by the passenger.NTSB FTW90DPA09Accident · Minor injuriesFinal reportMoffitt, William A. Windryder · Mesquite, TXThe power loss due to failure of the ignition system due to improper installation by the operator. A factor was the wire struck during the emerency descent.NTSB CHI90LA277Accident · 1 fatalLimited investigationFinal reportNavion L-17A · Fort Wayne, INPoor judgement of the pilot due to impairment from consumption of alcohol and use of a drug, and his failure to maintain proper altitude/clearance above wooded terrain. Darkness was a related factor.NTSB CHI90FA278Accident · Serious injuriesField investigationFinal reportBoeing 727-251 · Detroit, MIThe intentional activation of the auxillary power unit by the flight engineer, and the improper evacuation procedures by the pilot in command. An associated factor in the accident was the APU circuit breakers were not pulled by company maintenance personnel.NTSB ATL90LA186Accident · No injuriesLimited investigationFinal reportCessna 172N · Stokesdale, NCThe failure of the engine driven oil pump which resulted in oil starvation to the engine. Factors were: the faa's failure to provide sufficient standards for airworthiness directive compliance, and the rough terrain.NTSB ATL90LA182Accident · Serious injuriesLimited investigationFinal reportHelio HST-550A · Mobile, ALThe pilot's intentional attempted takeoff with a known tailwind component. Factors relating to the accident were the tailwind, trees and utility lines on the departure end of the takeoff area.NTSB SEA90LA172Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Brothers, ORThe pilot's improper flight planning and decisions that led to him flying into rising terraain while engaged in low level flight activities.NTSB SEA90FA197Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Bend, ORAn engine power loss due to fuel starvation as a result of a broken seal in the fuel injector servo. In addition, the pilot misjudged his approach into an open field.NTSB NYC90DGM03Accident · Minor injuriesFinal reportContinental Copters MK5A · Cranesville, PAThe pilot's inability to maintain control of the helicopter after the loss of a portion of the cyclic control assembly; this resulted in ground impact and post-impact fire.NTSB LAX90LA339Accident · No injuriesLimited investigationFinal reportWaco YMS · Kailua, HIImproper use of carburetor heat resulting in engine failure due to carburetor icing.NTSB DEN90LA194Accident · No injuriesLimited investigationFinal reportCessna 152 · Erie, COThe student pilot's misjudgement of distance and altitude, and the instructor's inadequate supervision.NTSB NYC90LA230Accident · No injuriesLimited investigationFinal reportCessna 150F · Colts Neck, NJThe pilot stalling the airplane during takeoff from a closed airport. Also causal to the accident was the pilot's decision to attempt the takeoff on the runway with high grass and to use one half the available runway lenght.NTSB LAX90DVA13Accident · Serious injuriesFinal reportBlaise Midget Mustang · Kernville, CAThe pilot's failure to maintain an airspeed sufficient to sustain flight during landing. A factor was the pilot's lack of expereince in this aircraft.NTSB CHI90LA276Accident · No injuriesLimited investigationFinal reportMooney M20E · Morrison, ILImproper maintenance of the propeller blade by unknown persons and the subsequent failure of the blade in fatigue during cruise flight. A factor was: unsuitable terrain.NTSB CHI90LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Amana, IAProper touchdown point not attained and go-around delayed by the pilot in command. Contributing factors were ATC communications inadequate and wet, grass runway with a tailwind environment plus a fence.NTSB ATL90LA180Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Fayetteville, TNThe pilot's premature flare which resulted in a loss of directional control at touchdown.NTSB ANC90LA185Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotes Lakes, AKThe pilot-in-command's encounter with turbulence while on final approach, and failure to maintain aircraft control.NTSB ANC90FA187Accident · No injuriesField investigationFinal reportPiper PA-18A · Birchwood, AKThe pilot-in-command's failure to correctly analyze the wind and its effect on the airplane during the landing; thereby failing to maintain proper directional control.NTSB NYC90DNC01Accident · Serious injuriesFinal reportCessna 180E · Kingston, NHAn inflight collision with water while maneuvering for a forced landing. A factor to the accident was a power loss due to the pilot's improper use of the mixture control.NTSB MIA90FA191Accident · Serious injuriesField investigationFinal reportErco 415 · Titusville, FLWas partial loss of engine power due to foreign object obstruction of the inlet of the carburetor.NTSB MIA90FA190Accident · 1 fatalField investigationFinal reportAyres S2R-T34 · Thornton, MSThe improper drilling of a hole in the spar cap by a mechanic resulting in the initiation of fatigue cracking in the spar cap and subsequent failure of the spar cap and inflight separation of the wing.NTSB LAX90LA342Accident · No injuriesLimited investigationFinal reportPiper J-3C-115 · Wickenburg, AZThe pilot's failure to maintain directional control.NTSB CHI90LA274Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob 109A · Waukesha, WIThe pilot's failure to maintain adequate clearance and visual lookout for the moving tractor.NTSB BFO90LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Maryville, KYThe failure of a hydraulic brake line which resulted in a loss of fluid, and an inoperative brake system during landing roll.NTSB ATL90LA181Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Minturn, SCA previously fractured main wheel which had resulted from a hard landing. A factor in the accident was inadequate inspection by the operator.NTSB MIA90LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Cedar Key, FLThe failure of the pilot to execute a go-around after landing long.NTSB LAX90DUG10Accident · 2 fatalFinal reportELY Thorp T-18 · Claremont, CAA loss of control for undetermined reason(s).NTSB BFO90FA079Accident · 1 fatalField investigationFinal reportHughes 269C · Jefferson, MDThe failure of the tail rotor drive transmission system due to a worn tail rotor splined drive sleeve, and inadequate maintenance and/or inspection by the operator. Contributing to the loss of control was the student pilot's failure to maintain adequate rotor…NTSB ATL90FA179Accident · 3 fatalField investigationFinal reportCessna 421B · Jefferson, GAFailure of the pilot to perform the correct emergency procedures, when confronted with a loss of engine power, and his failure to maintain minimum control speed (VMC), which resulted in a loss of aircraft control.NTSB SEA90LA196Accident · Minor injuriesLimited investigationFinal reportBeech C-45H · Twin Falls, IDThe pilot's inability to maintain directional control during a takeoff in strong crosswind conditions.NTSB NYC90DEI03Accident · No injuriesFinal reportPiper PA28-180 · Elkhorn Lake, OHThe pilot's improper decision to land on a short, wet grass strip. A contributing factor was the wet grass.NTSB MIA90LA192Accident · No injuriesLimited investigationFinal reportCessna 402B · St. ThomasSeparation of the left main landing gear torque tube bracket assembly due to sheared rivets from a previous hard side load landing which was not reported.NTSB MIA90LA188Accident · No injuriesLimited investigationFinal reportCessna 150M · Florida City, FLLoss of control during the take off roll from the dirt road followed by an on ground collision with shrubs.NTSB MIA90LA187Accident · Serious injuriesLimited investigationFinal reportRepublic RC-3 · Mulberry, FLAn engine failure which required an emergency landing off airport.NTSB LAX90FA332Accident · 4 fatalField investigationFinal reportCessna 500 · San Luis Obispo, CAThe pilot's improper IFR (instrument) procedure, and his failure to maintain the minimum descent altitude (mda) for the approach. The adverse weather was a related factor.NTSB FTW90LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Arlington, TXThe pilot's failure to properly flare the airplane for landing and his failure to initiate the proper recovery procedures following the bounced landing.NTSB FTW90FA186Accident · 2 fatalField investigationFinal reportMooney M20A · San Ysidro, NMFailure of the pilot to maintain adequate terrain clearance during a night VFR flight. Darkness and mountainous terrain were related factors.NTSB DEN90LA193Accident · Serious injuriesLimited investigationFinal reportCessna 310J · Colorado Spring, COThe loss of power on one engine due to excessive fuel pressure and the pilot's feathering of the wrong propeller. Factor(s) were: operation of aircraft with known deficiencies by pilot and operator.NTSB CHI90LA272Accident · Minor injuriesLimited investigationFinal reportCessna A150L · Terre Haute, INAn undetermined loss of engine power.NTSB SEA90LA194Accident · Minor injuriesLimited investigationFinal reportRoger A Hansen KR-2M · Shaniko, ORPilot's failure to maintain clearance from a road sign during landing ground roll. A factor in the accident was the failure of the engine exhaust system which resulted in high engine oil temperature.