NTSB investigations, 1990
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 ATL91LA002Accident · No injuriesLimited investigationFinal reportMooney M20E · Greensboro, NCThe failure of the rubber/metal coupling in the landing gear actuator assembly, which resulted in the inability of the pilot to lower and lock the landing gear.NTSB ANC91LA003Accident · No injuriesLimited investigationFinal reportBeech B55B · Eielson Afb, AKThe dual student's inadvertent, premature selection of the landing gear handle to the up position; thereby causing the landing gear system to retract. Contributing to the accident was the instructor's failure to monitor the dual student's action and take…NTSB ANC91LA002Accident · No injuriesLimited investigationFinal reportCessna 185B · Koyuktolik, AKPilot-in-command's failure to properly execute a stabilized approach to the first 1/3 of the runway. Contributing to the accident was the excessive airpseed maintained during the approach and landing.NTSB LAX91LA003Accident · 1 fatalLimited investigationFinal reportCessna 210 · Riverside, CAImpairment of the pilot from use of drugs (cocaine), and his failure to maintain clearance (or altitude) from the mountain. Factors related to the accident were: darkness and the pilot's psychological condtion (depression).NTSB FTW91LA004Accident · Minor injuriesLimited investigationFinal reportWaco RNF · Lampasas, TXThe failure of a cylinder intake valve spring.NTSB DEN91LA004Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Englewood, COThe pilot's inadequate preflight inspection.NTSB DEN91LA003Accident · 2 fatalLimited investigationFinal reportRaven S-55A · Bernalillo, NMThe pilot to maintain adequate visual lookout, resulting in an inflight collision with power lines.NTSB CHI91LA006Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Troy, MIThe pilot failed to refuel the aircraft prior to flight.NTSB CHI91LA005Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Ashland, KSThe pilot-in-command's exceeding the proper climb rate of the aircraft, and his not maintaining control of the aircraft to prevent a stall.NTSB BFO91LA001Accident · No injuriesLimited investigationFinal reportBeech B23 · Westminster, MDThe pilot's failure to maintain positive directional control during the landing. Improper crosswind compensation and a variable, gusty crosswind were contributing factors.NTSB NYC91LA003Accident · No injuriesLimited investigationFinal reportCessna A150M · Lincoln, RIOn ground collision with a tree while making a forced landing following loss of engine power due to a failed exhaust valve.NTSB MIA91LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rolling Fork, MSThe failure of the pilot to maintain wingtip clearance with tall grass at the edge of the runway during the ground roll.NTSB MIA91LA006Accident · No injuriesLimited investigationFinal reportCessna 150M · Tampa, FLThe pilot's decision to fly an airplane with known deficiencies. This resulted in a partial loss of engine power, and a ground collision with a fixed object.NTSB CHI91TL#01Accident · Minor injuriesClass 3Final reportAerospatiale AS350B · Wixom, MINTSB CHI91LA004Accident · No injuriesLimited investigationFinal reportBeech E-18 · Minneapolis, MNFailure of the pilot-in-command to maintain directional control of the aircraft during landing roll.NTSB MIA91LA005Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas DC-9-31 · Cape Canaveral, FLFailure of the captain to follow procedures, his improper in-flight planning/decision by allowing the aircraft to continue into the overhang (anvil) of a thunderstorm, failure of the passengers to abide by procedures/instructions concerning use of seat belts,…NTSB LAX91LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Kearny, AZThe pilot executing a left turn at an altitude insufficient to clear a corn field located in close proximity to the departure runway.NTSB LAX91DVW01Accident · Serious injuriesFinal reportMelton MMI · Death Valley, CAThe pilot's inaccurate calculation of fuel consumption and his decision to continue the flight with a malfunctioning fuel quantity indicator.NTSB FTW91DPG01Accident · Minor injuriesFinal reportCessna A-188 · Manila, ARThe pilot's failure to maintain proper clearance from power lines and the inadvertent stall.NTSB CHI91LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Emporia, KSGusty crosswinds, excessive flap setting, and lack of total experience in type of operation.NTSB CHI91LA003Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Midland, MIThe pilot did not refuel resulting in loss of engine power due to fuel exhaustion. The inadvertent stall encountered during the forced landing was also a cause.NTSB CHI91DER01Accident · Minor injuriesFinal reportCessna 206 · South St. Paul, MNThe inadvertent deployment of the drag parachute. Related factors are the pilot's improper remedial action, habit interference, and the reduced aircraft controllability.NTSB ANC91FA001Accident · Serious injuriesField investigationFinal reportHughes 500D · Kennsington, AKThe loss of control during takeoff due to dynamic rollover. Contributing to the accident was the pilot-in-command's selection of an uneven landing area.NTSB SEA91IA003Incident · No injuriesIncident investigationFinal reportCessna 551 · Elma, WAInadequate inspection of the electrical wire bundle assembly by maintenance personnel, and chafing/burning of the wire bundle.NTSB NYC91LA002Accident · 2 fatalLimited investigationFinal reportForney 415D · Morrisville, NYThe pilot executing a left turn at an altitude insufficient to clear a corn field located in close proximity to the departure runway.NTSB MIA91LA004Accident · No injuriesLimited investigationFinal reportRobinson R22 B · Opa Locka, FLFailure to use carburetor heat.NTSB MIA91LA003Accident · No injuriesLimited investigationFinal reportBeech C-90 · Tampa, FLThe lack of lubrication by maintenance personnel of the nose landing gear actuator.NTSB LAX91FA001Accident · 1 fatalField investigationFinal reportMooney M20K · Flagstaff, AZThe pilot's decision to operate the aircraft with a known discrepancy; inadequate maintenance procedures; and the pilot's inflight loss of control due to smoke and fumes in the cockpit.NTSB DEN91FA002Accident · 1 fatalField investigationFinal reportCessna T210N · Gypsum, COThe pilot flying into known adverse icing and thunderstorm weather conditions which resulted in the loss of control of the aircraft.NTSB CHI91LA002Accident · No injuriesLimited investigationFinal reportGulfstream American 690B · Willow Springs, MOThe airplanes encounter with a static discharge, turbulence and a downdraft in the clouds which were associated with severe meteorological conditions.NTSB SEA91LA002Accident · No injuriesLimited investigationFinal reportBeech 58 · Seattle, WAThe pilot did not flare the airplane on landing. Factors related to the accident were: the pilot did not adequately recover from a bounced landing and the nose gear assembly failed in overload.NTSB SEA91LA001Accident · Serious injuriesLimited investigationFinal reportCessna T210K · Everett, WAA loss of engine power for undetermined reasons.NTSB NYC91FA001Accident · 3 fatalField investigationFinal reportCessna 172P · Gorham, NHImproper planning/decision by the pilot, and his failure to maintain proper altitude while flying over mountainous terrain. Factors related to the accident were: darkness, mountainous terrain, and pilot fatigue.NTSB MIA91LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa Locka, FLPartial loss of engine power for undetermined reasons resulting in a forced landing.NTSB MIA91FA001Accident · 1 fatalField investigationFinal reportErik K. Van Der Kaay Marco J-5 · Clearwater, FLThe pilot's inadvertent deployment of the air brakes at a low altitude.NTSB CHI91LA001Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace BAE Jetstream 3201 · St. Louis, MOVisual outlook inadequate by the ground personnel. Contributing factors were lack of total experience in type of operation and a dusk light condition.NTSB FTW91GA001Accident · No injuriesFinal reportMcdonnell Douglas 369E · Anadarko, OKFailure of the pilot to maintain proper visual lookout prior to and during departure.NTSB DEN91LA001Accident · No injuriesLimited investigationFinal reportRaven S-60A · Harrison, ARThe student pilot's improper inflight planning and inaccurate evaluation of the surface weather. A factor was the unfavorable wind.NTSB ANC90LA189Accident · 1 fatalLimited investigationFinal reportMaule M-4-210C · 60 E Of Bethel, AKContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude and clearance above mountainous terrain. Factors related to the accident were: darkness, adverse terrain and weather conditions, the…NTSB ANC90LA188Accident · No injuriesLimited investigationFinal reportCessna 180 · Swift River, AKThe pilot-in-command's failure to understand the performance data of the airplane, and his failure to identify unsuitable terrain.NTSB NYC90DHM26Accident · No injuriesFinal reportPalen Sopwith Dolphin · Reinbeck, NYUndetermined engine failure during low altitude operations.NTSB LAX90DUQ02Accident · 1 fatalFinal reportFolland Gnat T-1 · Mojave, CAThe pilots failure to correct a descent during a low level aerobactics.NTSB LAX90DUG11Accident · Serious injuriesFinal reportVolksplane WE-1 · El Mirage, CAThe pilot's failure to maintain airspeed.NTSB FTW90LA187Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Greers Ferry, ARThe pilot's decision to penetrate adverse weather and the resultant spatial disorientation. Factors were the weather conditions and the pilot's lack of instrument training/experience.NTSB FTW90DQG05Accident · No injuriesFinal reportCessna T188C · Nazareth, TXThe pilot's failure to maintain obstacle clearance.NTSB CHI90DEV10Accident · 1 fatalFinal reportCarlson Commander Elite · Jerseyville, ILThe pilot's failure to maintain control of the gyroplane.NTSB CHI90DEE10Accident · 1 fatalFinal reportJeff Pierson Pierson Pusher · Kankakee, ILA loss of engine power due to activation of carburetor choke and an inadvertent stall during the forced landing.NTSB CHI90DEC05Accident · No injuriesFinal reportSchleicher ASW-22 · Richmond, MIThe pilot's premature retraction of the flaps allowing the glider to settle into an unusually low tow altitude.NTSB ATL90LA185Accident · No injuriesLimited investigationFinal reportCessna 210 · White Plains, GAThe fuel starvation to the engine for undertermined reasons.NTSB ATL90LA184Accident · No injuriesLimited investigationFinal reportCessna 152 · Dothan, ALThe student pilot's selection of the wrong runway and the subsequent loss of directional control during takeoff. The pilot's improper usage of flight controls, presence of crosswind conditions, and his overall lack of experience were factors in the accident.