NTSB investigations, 1990
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 MIA91LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa Locka, FLThe pilot's failure to maintain a positive rate of climb while maneuvering to avoid a flock of birds, resulting in an in flight collision with trees. Factor(s) included: attention diverted.NTSB DEN91LA023Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Clifton, TXInadvertent stall. Factors were: tailwind, wrong runway selected, and failure to raise flaps.NTSB DEN91LA021Accident · No injuriesLimited investigationFinal reportGulfstream AA-5B · Erie, COImproper flare by the pilot, which resulted in a hard landing. A realted factor was: low light condition at dusk.NTSB CHI91LA030Accident · No injuriesLimited investigationFinal reportCessna 177 · Mount Ayr, IAProper touch-down point not attained and go-around delayed by the PIC. Contributing factors were a downwind, crosswind, weather evaluation misjudged, wrong runway selected and lack of total experience by the PIC.NTSB ANC91FA014Accident · 1 fatalField investigationFinal reportCessna 170 · 40 W Of Clear, AKThe non-instrument rated pilot-in-command's loss of control while attempting to operate under visual flight rule while in instrument meteorological conditions. Contributing to the accident was the whiteout condition created by the vast expanse of white lake…NTSB NYC91FA035Accident · 1 fatalField investigationFinal reportCessna 414A · Atlantic City, NJFailure of the pilot to follow the published ILS procedure and his continued descent below the decision height. Darkness and the adverse weather conditions were related factors.NTSB LAX91LA046Accident · No injuriesLimited investigationFinal reportCessna T303A · Santa Ana, CAThe pilot's misjudging the distance between the airplane and hangar.NTSB LAX91LA038Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Phoenix, AZStrength degradation of the kevlar suspension cables, due to previous heat damage. Factors related to the accident were: failure of the quick release line to release, and susceptibility of kevlar suspension cables to heat.NTSB LAX91FA037Accident · 1 fatalField investigationFinal reportRobinson R22Beta · Simi Valley, CAA divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact to the tailboom and cockpit.NTSB FTW91LA018Accident · No injuriesLimited investigationFinal reportCessna 172L · Mount Ida, ARThe pilot in command's failure to compensate for the adverse wind conditions which resulted in a loss of control on touchdown. A factor was the gusty crosswind.NTSB FTW91DRD02Accident · 2 fatalFinal reportPiper PA-J3C-65 · Mer Rouge, LAAn inadvertent stall at an altitude too low to allow for recovery.NTSB ATL91LA021Accident · No injuriesLimited investigationFinal reportCessna 150 · Arlington, TNThe student pilot's failure to maintain directional control during landing. A factor in this accident was gusty winds.NTSB NYC91LA036Accident · 3 fatalLimited investigationFinal reportPiper PA-28-140 · Cheswold, DEA loss of control in flight, by a non-instrument rated pilot in instrument meteorological conditions. Factors related to the accident were: his decision to fly after he received weather briefings which inlcuded 'VFR flight not recommended'.NTSB NYC91FA034Accident · 2 fatalField investigationFinal reportCessna 172M · Perham, METhe pilot initiating flight into known icing conditions which resulted in an accumulation of airframe ice and a failure to maintain airspeed. The contributing factor was the existing icing conditions.NTSB FTW91FA017Accident · 1 fatalField investigationFinal reportBeech B55 · England, ARThe pilot's misjudgement of altitude, which resulted in his failure to arrest descent from a dive. The pilot's impaired judgment from consumption of ethanol (alcohol) was a factor.NTSB DEN91LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sherman, TXA pilot induced inadvertent stall.NTSB BFO91LA018Accident · No injuriesLimited investigationFinal reportBell 47J2A · Matoaca, VAThe failure of four propeller retention and the pilot's misjudgement of the forced landing approach.NTSB SEA91LA024Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Kamiah, IDThe pilot's inadequate compensation for the wind conditions.NTSB SEA91LA022Accident · No injuriesLimited investigationFinal reportBeech 65-88 · Spokane, WAThe pilot's misjudgement of his touchdown due to disorientation caused by his lack of forward visibility created by an accumulation of ice on the windshield.NTSB SEA91FA021Accident · 3 fatalField investigationFinal reportBeech 95-55 · Hayden Lake, IDThe pilot's improper IFR procedure in failing to intercept the proper glideslope path.NTSB LAX91LA041Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Young, AZThe pilot selected the wrong runway and attempted to land with a tailwind.NTSB LAX91FA036Accident · 2 fatalField investigationFinal reportBeech 95-A55 · Woodland, CAThe pilot's misjudgement of his altitude to assure terrain clearance during a night visual approach. Contributing factors were the dark night, unlit terrain, the pilot's lack of recent night time, the pilot's lack of familiarity with the airport, and an…NTSB CHI91FA031Accident · 4 fatalField investigationFinal reportPiper PA-32-RT300 · Gaylord, MIThe pilot's failure to maintain adequate terrain clearance. Factors which contributed to the accident were: the dark night, adverse weather conditions, and the pilot's overconfidence in continuing VFR flight into these conditions.NTSB CHI91DEX01Accident · Minor injuriesFinal reportCessna 210G · Indianapolis, INInadequate maintenance and inspection of the airplane resulting in an engine power loss due to water and fuel contamination. A contributing factor was the dark night.NTSB NYC91LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHAircraft control was not maintained by the student pilot.NTSB NYC91DFA01Accident · No injuriesFinal reportLowe/Law Glasair SH-3 · Kingston, NYA hard landing that collapsed the left main gear due to overload failure of the trunion.NTSB ATL91FA018Accident · 1 fatalField investigationFinal reportCessna 182E · Blairsville, GAFuel exhaustion resulting in engine stoppage, and the pilot's failure to obtain fuel earlier in the flight.NTSB SEA91FA020Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Albion, IDThe pilot-in-command's failure to maintain control of the airplane in instrument meteorological conditions. Factors which contributed to the accident were the pilot's apprehension of flying in the forecasted weather, and the adverse weather conditions…NTSB MIA91FA029Accident · 1 fatalField investigationFinal reportCessna 172M · Homestead, FLThe failure of the pilot to insure adequate fuel was present in the aircraft for the flight resulting in loss of engine power due to fuel exhaustion.NTSB LAX91LA035Accident · Serious injuriesLimited investigationFinal reportCessna 210M · Fallbrook, CAThe failure of the number 5 cylinder piston connecting rod due to bending and subsequent fatigue fracture. Contributing to the accident was the improper starting procedure accomplished by an unidentified person which resulted in excessive fuel in the cylinder…NTSB LAX91FA040Accident · 2 fatalField investigationFinal reportBeech S-35 · Kingman, AZProper altitude not maintained. Contributing to the accident was: the lack of supplemental oxygen on board the aircraft, pilot fatigue, improper use of the auto pilot, and pilot complacency.NTSB DEN91FA020Accident · Serious injuriesField investigationFinal reportCessna T210L · Clovis, NMAn inadvertent descent into the ground while conducting a non-precision instrument approach, as a result of the pilot failing to stop his descent at mda. A factor is low visibility due to fog.NTSB ATL91LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Winston-Salem, NCFailure of a piston pin plug which resulted in a total loss of power. Factors in the accident were an inadequate engine overhaul which led to premature engine wear, and the pilot's failure to obtain proper maintenance following a loss of engine oil pressure.NTSB SEA91LA018Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Bremerton, WAThe pilot did not maintain altitude.NTSB NYC91LA032Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103A · Erwinna, PAThe student pilot's improper landing technique and the instructor's inadequate supervision.NTSB FTW91FA016Accident · 1 fatalField investigationFinal reportMBB BO 105CB4 · Cameron, LAThe company's maintenance personnel's failure to install the cyclic interconnect tube and their failure to inspect the helicopter prior to flight.NTSB SEA91FA019Accident · 1 fatalField investigationFinal reportCessna 206 · Pullman, WAThe pilot displayed inadequate inflight planning and decision making. Factors to the accident were: the weather was obscured, the dark night condition, and a proper altitude not maintained.NTSB NYC91LA031Accident · No injuriesLimited investigationFinal reportBeech B36TC · Caldwell, NJPremature rotation and an inadvertent stall. Factors include lack of total experience in this type of aircraft.NTSB NYC91LA030Accident · No injuriesLimited investigationFinal reportCessna 150H · Freeport, PAThe pilot's miscalculations of the amount of fuel on the airplane required for the flight. A factor was the unsuitable terrain.NTSB MIA91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Inverness, MSThe student pilot's failure to refuel the airplane. Factors were: uel exhaustion, the pilot's lack of total aeronautical experience, and soft terrain.NTSB FTW91LA015Accident · No injuriesLimited investigationFinal reportCessna 195 · N. Little Rock, ARThe failure of the right brake system to release after application for unknown reasons.NTSB DEN91IA019Incident · No injuriesIncident investigationFinal reportBeech J-35 · Brighton, COThe failure of the engine fuel feed line resulting in a complete loss of power. Contributing to the incident was improper installation of the fuel feed transducer.NTSB CHI91DCQ01Accident · 1 fatalFinal reportRobert Bressler Pitts S-1E · St. Francis, KSThe failure of the pilot to maintain aircraft control.NTSB MIA91LA027Accident · 2 fatalLimited investigationFinal reportCessna 172P · Atlantic Ocean (Atlantic Ocean)Delay of the pilot to obtain assistance and, as a result, he ditched the airplane near a boat due to a low fuel supply.NTSB LAX91LA033Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Tuba City, AZFailure of the piston rings which reduced the available engine power, and the pilot's continued operation of his airplane with a known engine deficiency during the relatively high density altitude conditions.NTSB LAX91LA032Accident · 1 fatalLimited investigationFinal reportCessna 172RG · San Clemente, CAThe pilots selection of improper cruise altitude while operating under a low overcast on a dark night. A factor in the accident was fatigue and lack of sleep.NTSB LAX91DXQ01Accident · Minor injuriesFinal reportPitts S-1E · Carson City, NVThe pilot's failure to maintain directional control during takeoff roll and the abrupt pullup to a premature takeoff.NTSB FTW91DRG01Accident · 1 fatalFinal reportTaylor Titch MK III · Seguin, TXThe pilot lost control at low level. Factors were the pilot attempting aerobatic maneuvers with insuffient altitude for recovery.NTSB SEA91LA017Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Boise, IDThe pilot's delaying remedial action after a poor landing approach.NTSB NYC91LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-32-301R · Alton, NHThe total loss of engine power for undetermined reasons. Contributing to the severity of the accident was the unsuitable terrain in which the forced landing was made.