NTSB investigations, 1990
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 CHI91FA011Accident · 3 fatalField investigationFinal reportCessna 172P · Fort Wayne, INThe failure of the pilot to maintain an airspeed above stalling speed. Factors associated with the accident are premature rotation and the pilot's lack of recent total experience.NTSB ANC91LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-14 · Port Heiden, AKThe pilot's failure to maintain directional control during takeoff. Contributing to the accident were the crosswind, pilot's failure to compensate for the crosswind, the soft runway, and lack of total experience in type of aircraft.NTSB MIA91WA012Accident · 6 fatalForeign investigationPiper PA-34-200T · Lascahobas, HaitiNTSB FTW91LA006Accident · No injuriesLimited investigationFinal reportBeech 77 · Arkadelphia, ARFuel starvation to the engine due to a blocked fuel system vent. Factors contributing to the accident were the pilot's inadequate preflight, and contacting high vegetation and low trees during the landing roll.NTSB ANC91LA006Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Madison Creek, AKThe pilot's premature lift off at an inadequate airspeed. Contributing to the accident was the unplowed snow on the runway.NTSB SEA91FA144Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mullan, IDThe pilot's VFR flight into instrument meteorological conditions (IMC). The adverse weather and terrain conditions were related factors.NTSB NYC91LA011Accident · No injuriesLimited investigationFinal reportRobinson R22 · Woonsocket, RIPilot's failure to maintain sufficient altitude above the terrain to avoid getting the right skid caught in the grass, resulting in a loss of control.NTSB NYC91DHA01Accident · 1 fatalFinal reportJames Cote Kolb Twinstar MK II · Gilbertsville, PAThe failure of the pilot to maintain control of the aircraft after an interuption of power.NTSB MIA91LA010Accident · No injuriesLimited investigationFinal reportAmerican AA-5 · Cape Coral, FLA partial loss of engine power, caused by mechanical failure of the number 3 cylinder engine exhaust valve, for an undetermined reason.NTSB MIA91LA009Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · De Funiak Spgs, FLThe loose fuel cap and failure of the pilot to assure the aircraft was properly preflighted, which resulted in fuel siphoning and subsequent fuel exhaustion. Factors related to the accident were: faulty fuel quantity gages, the pilot's decision to fly with…NTSB CHI91LA012Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Mason, MIThe pilot's failure to maintain directional control. A factor in the accident is the pilot's lack of total experience in the accident type airplane.NTSB CHI91LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNA poorly planned approach, and failure to take remedial action by the pilot.NTSB CHI91GA014Accident · 1 fatalFinal reportCessna 172P · Williamsburg, IAThe pilot-in-command's abrupt pull-up to avoid an obstacle. Contributing was the pilot-in-command's diverted attention to activities on the ground.NTSB ATL91LA003Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Lexington, NCThe pilot's failure to establish an approach profile which would have allowed him to make a safe landing on the runway. The pilot misjudged his altitude and airspeed throughout the approach. A factor to the accident was the collision with the railroad berm.NTSB SEA91LA006Accident · No injuriesLimited investigationFinal reportMooney M20F · Casper, WYThe loss of engine power due to fatigue fracture of the number 2 cylinder connecting rod. Factors related to the accident were: rough and uneven terrain at the accident site and the lack of suitable terrain for forced landing.NTSB NYC91DNC01Accident · 2 fatalFinal reportSkytek Skyseeker MK II · Chapman, MEIn-flight failure of the outboard section of the wing, and the loss of aircraft control. Due to the unauthorized structural modification by the pilot/owner.NTSB LAX91LA011Accident · No injuriesLimited investigationFinal reportBeech C35 · Independence, CAThe pilot's failure to attain an altitude adequate to avoid colliding with ojbects during takeoff.NTSB LAX91LA009Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Agua Dulce, CAA failure of the pilot to perform preflight planning.NTSB BFO91LA003Accident · Serious injuriesLimited investigationFinal reportMooney M20M · Culpeper, VAIntergranular cracking (fatigue) failure of the exhaust clamp, which resulted in a disconnected exhaust manifold (tailpipe), and subsequent fire in the engine compartment.NTSB NYC91LA010Accident · No injuriesLimited investigationFinal reportSwearingen SA-26AT · Monongahela, PAThe pilot's inadequate monitoring of the fuel burn which resulted in total fuel exhaustion. Factors which contributed to the accident were: the pilot's limited experience in the make and model of airplane, an erroneous fuel quantity indication, and the…NTSB LAX91LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Watsonville, CAThe failure of the pilots of both aircraft to see and avoid the other.NTSB ANC91LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · King Salmon, AKInadvertant stall during an aborted landing.NTSB ANC91GAMS1Accident · 3 fatalFinal reportGulfstream Aerospace 690C · Deadhorse, AKMissing aircraft.NTSB SEA91LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Pullman, WAThe student pilot's failure to maintain directional control.NTSB SEA91LA004Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Hamilton, MTThe pilot's inadequate compensation for wind conditions.NTSB NYC91LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Dayton, OHA carburetor fire due to an engine backfire. A factor relating to the accident was improper remedial action taken by the pilot to extinguish the engine fire.NTSB LAX91LA008Accident · Serious injuriesLimited investigationFinal reportBell 47G4 · Merced, CALoss of engine power for an undetermined reason.NTSB LAX91DUM01Accident · 1 fatalFinal reportPiper PA28-140 · El Cajon, CAThe pilot's failure to maintain flying speed. Contributing to the accident was an engine power loss for undetermined reasons.NTSB CHI91LA008Accident · No injuriesLimited investigationFinal reportCessna 150 · Plymouth, MIThe student pilot's failure to maintain directional control during takeoff ground run. A factor in the accident was the soft terrain.NTSB LAX91LA006Accident · No injuriesLimited investigationFinal reportCessna 150 · Riverside, CAThe pilot misjudged the airplane's altitude and the improper bounced landing recovery procedure. Contributing to this accident was the student pilot's total lack of expereince.NTSB LAX91FA005Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Redlands, CAA total loss of engine power due to fuel starvation as a result of a fuel system leak of an undetermined origin.NTSB DEN91LA006Accident · No injuriesLimited investigationFinal reportCessna T210M · Englewood, COEngine failiure resulting from maintenance discrepancies.NTSB ANC91LA004Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain directional control. Contributing to the accident was the excessive taxi speed and inadequate maintenance on the brakes by the pilot.NTSB NYC91LA007Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Erwinna, PAThe pilot's failure to maintain directional control during the take off roll.NTSB FTW91LA005Accident · No injuriesLimited investigationFinal reportCessna T210L · Lake Providence, LAThe pilot's decision to enter an area of forecast thrunderstorms. The factor was the severe downdraft encountered.NTSB FTW91LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Claremore, OKFailure of pilot in command to insure the aircraft contained enough fuel for the flight resulting in engine failure due to fuel exhaustion.NTSB NYC91FA006Accident · 2 fatalField investigationFinal reportCessna 152 · Griswold, CTA broken ehaust valve spring that resulted in a partial loss of power. Factors related to the accident were: darkness, lack of suitable terrain, and failure of the occupants to use their shoulder harnesses.NTSB NYC91FA005Accident · 4 fatalField investigationFinal reportBeech V35B · Ottawa, OHFailure of the pilot to follow the proper instrument procedure and maintain the minimum descent altitude (mda) during an approach to the airport at night in instrument meteorological conditions.NTSB LAX91LA004Accident · 1 fatalLimited investigationFinal reportMooney M20K · Rio Linda, CAThe airplane's ground collision with an unauthorized person who was located on the active runway. A contributing factor was related to the nighttime (light) condition which limited the pilot's ability to see the person prior to the impact.NTSB DEN91FA005Accident · Serious injuriesField investigationFinal reportBeech P35 · Aurora, COInadvertent stall. Factors were his decision to disregard in-flight weather advisories, continued flight into known adverse weather, and icing conditions and the flight into the known adverse weather.NTSB BFO91LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Indian Head, MDThe student pilot's failure to maintain adequate aircraft control during the landing flare/touchdown. Contributing factors are his lack of total flight experience and his improper technique when raising flaps during an attempted go-around.NTSB ATL91LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Valdosta, GAThe student pilot's failure to maintain directional control during a takeoff attempt. Factors to the accident were the student's overall lack of flight experience, and the reported wind gust.NTSB NYC91LA008Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Moscow, PAA hard landing due to the failure of the pilot to properly arrest his descent rate and the failure of the flight instructor to adequately monitor the actions of the pilot.NTSB NYC91LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Emlenton, PAThe pilot's failure to maintain adequate airspeed during the landing. The turbulence contributed to the accident.NTSB MIA91FA008Accident · Serious injuriesField investigationFinal reportMooney M20C · Kissimmee, FLMalfunction of both magnetos due to deterioration of the coils, failure of maintenance personnel to comply with an airworthiness directive, and failure of the pilot to maintain adequate visual lookout while on an approach for an emergency landing. Factors…NTSB LAX91LA007Accident · No injuriesLimited investigationFinal reportCessna 182M · Bakersfield, CAThe pilot failed to properly recover from the bounced landing. Contributing to the accident was the pilot's lack of familiarity with the airplane.NTSB FTW91FA002Accident · 1 fatalField investigationFinal reportEnstrom F28-C · Mesquite, TXInstallation error of company maintenance personnel. Factors were the unsuitable terrain, the tailwind, the inability of the pilot to maintain main rotor RPM, and the inadequate annual inspection by company maintenance personnel.NTSB DEN91LA007Accident · Minor injuriesLimited investigationFinal reportBalloon Works AX9 · Cedar Crest, NMPilot's delayed precautionary landing and the subseuqent fuel exhaustion. A factor was the encounter with high winds in flight.NTSB DEN91DTM01Accident · Serious injuriesFinal reportHistorical A-001 · Durango, COEngine failure due to carburetor ice. A factor in the accident was the lack of carburetor heat equipment installed in the aircraft.NTSB BFO91LA013Accident · No injuriesLimited investigationFinal reportCessna 421B · Morganfield, KYLost of power of both engines due to the pilot's mismanagement of the fuel system.