NTSB investigations, 1990
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 LAX90DVA10Accident · Serious injuriesFinal reportGrumman-Schweizer G-164B · Westley, CAThe pilot's failure maintain obstacle clearance.NTSB CHI90LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Roseville, ILMisjudged flare for landing, an improper recovery from a bounced landing, and his failure to maintain directional control.NTSB CHI90FA236Accident · 7 fatalField investigationFinal reportPiper PA-32R-300 · Watertown, WIInitiation of VFR flight into adverse weather and instrument meteorologial conditions. Factors which contributed to the accident were the adverse weather conditions and the pilot's self-induced pressure to maintain currency.NTSB ATL90LA164Accident · No injuriesLimited investigationFinal reportCessna 182N · Knightdale, NCThe failure of the pilot to execute timely go around procedures. The pilot's lack of experience in this make and model of airplane were factors in the accident.NTSB ATL90LA160Accident · No injuriesLimited investigationFinal reportCessna 172P · Lawrencevile, GAThe pilot's failure to maintain directional control during the landing roll.NTSB ANC90LA148Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Cold Foot, AKThe pilot-in-command's failure to maintain flying speed.NTSB NYC90DEG02Accident · 1 fatalFinal reportTrice Pitts Special S-1S · Hamilton, OHThe loss of engine power for undetermined reasons.NTSB LAX90LA291Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Weaverville, CAThe pilot's failure to maintain directional control of the aircraft. The existing wind conditions and the ditch that was located near the runway were factors in the accident.NTSB LAX90DVA09Accident · No injuriesFinal reportRockwell S2R · Mendota, CALoss of engine power for an unknown reason. Darkness was a related factor.NTSB FTW90LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kansas, OKStudent pilot's failure to execute a go-around in a timely manner.NTSB CHI90LA238Accident · No injuriesLimited investigationFinal reportMooney M20B · Winfield, KSNon-compliance of an airworthiness directive by maintenance personnel.NTSB CHI90FA235Accident · 1 fatalField investigationFinal reportCessna 180 · Howell, MIThe pilot's failure to maintain adequate clearance above terrain while maneuvering during takeoff. A factor in the accident was the pilot's attempt to display the aircraft's performance.NTSB CHI90DEP09Accident · Serious injuriesFinal reportCessna 182 · Columbus, WIThe skydiver's panic and failure to depart the aircraft as instructed. Contributing was the skydiver's lack of total experience in this type of operation.NTSB NYC90LA197Accident · No injuriesLimited investigationFinal reportRobinson R-22HP · Islip, NYImproper use of flt controls.NTSB NYC90DHD03Accident · Minor injuriesFinal reportHeinrichs Rand KR-2 · Barnegat, NJThe loss of engine power due to magneto failure.NTSB MIA90FA171Accident · 2 fatalField investigationFinal reportNeal Christen Eagle II · Akron, ALFailure of the pilot to maintain control of the aircraft and to recover from (or avoid) a subsequent (flat) spin. Factors related to the accident were: the pilot's failure to follow established procedures, his lack of familiarity with the aircraft, and the…NTSB LAX90LA290Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Soda Springs, CAEngine failure due to inadequate vapor recovery system (inadequate aircraft maintenance/service) and incorrect fuel grade. A factor in the accident was unsuitable terrain.NTSB DEN90LA171Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Silver City, NMThe pilot's improper planning which resulted in a flight in conditions which exceeded the performance capability of the aircraft. The high density altitude was a factor.NTSB DEN90FA170Accident · 2 fatalField investigationFinal reportBeech J35 · Santa Fe, NMFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB CHI90DCA02Accident · No injuriesFinal reportFisher Flying Products Classic BI Plane · Memphis, MOThe failure of the pilot to maintain directional control of the airplane during the landing roll. The pilot's lack of total aviation experience was a related factor.NTSB BFO90LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Charleston, WVFuel exhaustion due to fatigue failure of a fuel line. Factors related to the accident were: lack of suitable terrain and obstructions (trees & utility pole) in the emergency landing area.NTSB ANC90LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Igiugig, AKThe pilot-in-command's failure to maintain directional control on landing. Contributing to the accident was unsuitable terrain selected by the pilot for landing.NTSB ANC90LA147Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350-B · Juneau, AKFailure of the free turbine intermediate pinion driven gear and subsequent disintegration of the free turbine assembly.NTSB NYC90LA195Accident · Serious injuriesLimited investigationFinal reportBeech BE-19 · Shirley, NYFailure of the PIC to supervise the actions of the dual student.NTSB LAX90LA289Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Goleta, CAThe loss of engine oil pressure for undetermined reasons.NTSB FTW90DPG09Accident · 1 fatalFinal reportGrumman G164A · Osceola, ARThe pilot's failure to maintain proper clearance from the power lines.NTSB CHI90LA232Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Lees Summit, MOCheck list not followed, fuel system not understood, and fuel boost pump selector improperly used, by the PIC.NTSB CHI90FA233Accident · No injuriesField investigationFinal reportPiper PA-23-160 · Odell, ILA loss of left engine power due to oil accumulation in the right magneto and a non-usable spark lead from the left magneto. In addition, the right engine was unable to provide adequate power to maintain altitude due to a partial blockage in the carburetor by…NTSB BFO90LA069Accident · No injuriesLimited investigationFinal reportCessna 170B · Frederick, MDFatigue failure of the left main gear wheel axle.NTSB SEA90LA164Accident · No injuriesLimited investigationFinal reportCessna A185F · Ovando, MTThe pilot's misjudgement of altitude and distance to the runway, while on final approach, and his failure to attain the proper touchdown point for landing. The fence was a related factor.NTSB NYC90LA196Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Stow, MAThe pilot's failure to properly plan the approach which resulted in the pilot misjudging the touch down point and landed long.NTSB NYC90LA194Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Burdett, NYThe pilot did not properly compensate for the cross wind and failed to maintain directional control during takeoff.NTSB NYC90DGT01Accident · Minor injuriesFinal reportCalvart HP-18 · York Springs, PAThe glider pilot's misjudged approach to landing, which resulted in the glider overshooting the landing field and impacting trees.NTSB DEN90DQA03Accident · No injuriesFinal reportPiper PA-25-235 · Fabens, TXEngine failure due to shorting of the magneto's 'p' lead, and failure of the exhaust manifold.NTSB CHI90LA234Accident · No injuriesLimited investigationFinal reportBeech P-35 Bonanza · Joliet, ILThe delay in initiating the aborted takeoff.NTSB ANC90LA145Accident · No injuriesLimited investigationFinal reportCessna 185B · Mcgrath, AKFailure of the left inside wheel bearing, for undetermined reasons.NTSB ANC90FA146Accident · 2 fatalField investigationFinal reportCessna A150 · Kenai, AKPilot-in-command's failure to maintain control of the airplane.NTSB NYC90LA193Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-35 · Erwinna, PAInadvertent release of the tow line at low altitude. A contributing factor was the landing in unsuitable terrain.NTSB NYC90FA192Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Saltaire, NYThe pilot misjudged his altitude.NTSB LAX90LA283Accident · Minor injuriesLimited investigationFinal reportBell 206B II · San Francisco, CAThe pilot's failure to maintain directional control of the helicopter. Contributing to the accident was the pilot's decision to operate the helicopter in a flight regime conducive to unanticipated right yaw.NTSB LAX90DXQ04Accident · Serious injuriesFinal reportBell UH-1B · Bieber, CAThe pilot's failure to maintain aircraft control when intentionally slowing his aircraft to off load water on fire. Contributing to the accident was the pilot's failure to arm and release the external load.NTSB FTW90DPG08Accident · Serious injuriesFinal reportAir Tractor AT-301 · Corning, ARBlockage of the carburetor Air intake by a collapsed Air induction hose due to improper maintenance by an unknown party.NTSB CHI90LA231Accident · No injuriesLimited investigationFinal reportHughes 369E · Grand Forks, NDThe instructor pilot's (cfi's) delay in taking remedial action after he and/or the student failed to attain the proper touchdown point for a run-on landing. Factors related to the accident were: the proximity of the barracade and the student's delay in…NTSB CHI90LA230Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hawley, MNThe failure of the PIC to retain control of the airplane during the landing sequence.NTSB CHI90FAMS3Accident · 2 fatalMissing aircraftFinal reportCessna 172M · Kewaunee, WIUndetermined.NTSB CHI90DEC04Accident · Serious injuriesFinal reportBell 47 D-1 · Stockbridge, MIThe restricted visual lookout which resulted from the canopy fogging up.NTSB BFO90FA070Accident · 2 fatalField investigationFinal reportCessna 150G · Ridgeway, VAFailure of the pilot to maintain adequate airspeed, which resulted in a stall and inflight collision with the terrain.NTSB ANC90LA144Accident · No injuriesLimited investigationFinal reportCessna 172 · Seward, AKThe pilot in command's selection of the wrong runway for wind conditions and his failure to abort landing in a timely manner resulting in overrun of the runway and on ground collision with terrain.NTSB NYC90LA191Accident · No injuriesLimited investigationFinal reportCessna 150 · Salem, OHThe airplane overran the end of the runway into a corn field after an aborted takeoff, due to the engine cowling door opening. Contributing to the accident was pilot's delay in aborting the takeoff.NTSB NYC89LA220Accident · No injuriesLimited investigationFinal reportMicalizio BD-5 · Montgomery, NYThe pilot's failure to maintain control of the homebuilt airplane while performing initial high-speed taxi tests. The pilot's lack of flight experience in the accident make and model airplane was a related factor.