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 FTW90IA169Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120 · College Station, TXPropeller and engine (powerplant) overspeed.NTSB FTW90DQG04Accident · 1 fatalFinal reportPiper PA-25-235 · Lubbock, TXFailure of the pilot to maintain adequate airspeed and altitude during a turn-around maneuver, which resulted in the aircraft stalling into the ground.NTSB DEN90LA190Accident · No injuriesLimited investigationFinal reportMooney M20B · Glenwood Spring, COWrong runway selection by the pilot, resulting in an overrun and a collision with a fence during landing roll. The prevailing tailwind, runway information and markings, and the pilot's failure to use the proper touchdown point are factors.NTSB DEN90LA179Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeview, ARThe pilot's failure to maintain alignment during landing.NTSB DEN90LA175Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-19 · Alamogordo, NMThe pilot's failure to maintain control of the glider, which resulted in the pilot induced oscillations.NTSB DEN90LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28R201T · Longmont, COLoss of engine power due to fuel starvation for undetermined reasons resulting in a forced landing while the landing gear was still in transit.NTSB CHI90LA245Accident · No injuriesLimited investigationFinal reportCessna 172 · Farmington, MORemedial action was not attained by the CFI. Contributing to the accident was inadequate airspeed and porpoise encountered by the dual student pilot.NTSB CHI90LA243Accident · Serious injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Hamburg, MIPowerplant failure due to foreign object in the carburetor resulting in fuel starvation.NTSB CHI90LA242Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Blissfield, MIThe pilot's inadequate visual lookout which resulted in a collision with a utility wire.NTSB CHI90LA241Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Schaumburg, ILThe pilot's failure to attain a proper climb rate after takeoff. Factors related to the accident are misjudgement of the aircraft takeoff weight, and overconfidence in the ability of the aircraft.NTSB CHI90FA239Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Clark Lake, MIPoor judgement of the pilot due to consumption of alcohol, and his failure to maintain proper altitude and clearance above water, while performing aerobatic maneuvers.NTSB NYC90LA222Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Norridgewock, METhe pilot's improper preflight and inflight planning of the fuel, which resulted in fuel exhaustion and forced landing.NTSB NYC90LA200Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Ravenna, OHA power loss, due to contamination from deteriorating fuel tank sealant, and the pilot's failure to notice the contamination during preflight.NTSB NYC90FA199Accident · 3 fatalField investigationFinal reportPiper PA-31T2 · Mattapan, MAThe pilot's improper in-flight planning/decision, which resulted in his failure to maintain control of the aircraft. Factors related to the accident were: failure of the left fuel control unit, and the adverse weather conditions.NTSB MIA90LA176Accident · No injuriesLimited investigationFinal reportGrumman 164-A · Dundee, MSImproper maintenance repair by an unknown person that initiated the engine failure and the forced landing.NTSB MIA90LA173Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Hattiesburg, MSFailure of the pilot in command to attain adequate airspeed prior to liftoff during an attempted takeoff. The pilot then lost control of the airplane in flight. The pilot also delayed in his decision to abort the takeoff.NTSB LAX90LA303Accident · No injuriesLimited investigationFinal reportHughes 369D · Santa Monica, CAThe pilot's decision to exit the helicopter with the engine running and no one at the controls.NTSB LAX90LA302Accident · No injuriesLimited investigationFinal reportPiper PA38 · Chandler, AZThe student pilot's loss of control during takeoff. His inexperience in the aircraft and improper use of the flight controls were factors in the accident.NTSB LAX90LA299Accident · Minor injuriesLimited investigationFinal reportde Havilland DH-82A · Petaluma, CAThe pilot's failure to maintain directional control.NTSB FTW90FA164Accident · Serious injuriesField investigationFinal reportHughes 269C · Shreveport, LAThe pilot's failure to maintain clearance from the obstruction. Factors related to the accident were: the lack of visual ques due to the light conditions at dusk, the ground observer's lack of assistance and lack of experience in the type of operation, and…NTSB ATL90LA161Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Palmetto, GAThe pilot's operation of the airplane with known mechanical deficiencies. A factor in the accident was the improperly maintained condition of the magnetos.NTSB ANC90LA157Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kashvik Bay, AKThe pilot-in-command's improper preflight preparation and planning. Contributing to the accident was unsuitable terrain.NTSB ANC90LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Goose Bay, AKThe pilot-in-command's improper flare on touchdown.NTSB ANC90LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Kodiak, AKThe pilot-in-command's failure to maintain directional control and failure to maintain airplane control on landing.NTSB MIA90LA172Accident · No injuriesLimited investigationFinal reportPiper PA24-260 · Destin, FLThe pilots failure to obtain accurate wind information resulting in the airplane being blown off the runway on landing when a gust which exceeded the crosswind capability of the airplane was encountered.NTSB LAX90DUJ09Accident · 1 fatalFinal reportStits SA6B · Tucson, AZThe failure of the pilot to maintain aircraft control.NTSB FTW90MA161Accident · 3 fatalMajor investigationFinal reportGrumman G-159 · Houston, TXPartial failure of the left engine fuel pump, which resulted in a partial loss of power in the left engine, but not enough of a power loss to trigger and/or complete the autofeathering operation of the left propeller, thus allowing insufficient time for the…NTSB FTW90LA163Accident · No injuriesLimited investigationFinal reportCessna 180 · Saint Joseph, LAThe pilot's failure to maintain directional control and his use of excessive braking.NTSB FTW90DPG11Accident · No injuriesFinal reportAir Tractor AT401 · Altheimer, ARThe pilot's failure to align the airplane with the runway during landing.NTSB FTW90DPG10Accident · No injuriesFinal reportCessna 188A · Hunter, ARThe pilot's failure to maintain proper clearance above the crops.NTSB DEN90LA173Accident · No injuriesLimited investigationFinal reportCessna T-210-L · Edgewood, NMEngine failure due to a broken connecting rod. A factor was the rough uneven terrain available for the forced landing.NTSB ANC90LA152Accident · No injuriesLimited investigationFinal reportCessna 185 · Nenana, AKThe pilot's poor judgement, due to consumption of alcohol, and his failure to maintain directional control of the aircraft during the takeoff run.NTSB LAX90LA298Accident · No injuriesLimited investigationFinal reportBell 206B · California City, CAThe failure of the helicopter pilot to maintain adequate clearance from the jump aircraft. A factor in the accident was the inability of the jump aircraft pilot to maintain visual contact with the helicopter.NTSB LAX90LA297Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Chico, CAThe student pilot failed to maintain directional control during landing roll and the CFI failed to take remedial action.NTSB LAX90LA294Accident · No injuriesLimited investigationFinal reportCessna 180H · San Carlos, CAThe pilot's failure to maintain directional control of the aircraft during the landing. Contributing to the accident was the pilot's lack of total experience in tailwheel aircraft.NTSB LAX90IA293Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Los Angeles, CAImproper maintenance service by a company employee who allowed a foreign object (flashlight) to remain in the landing gear extend/retract linkage during a night servicing before the flight.NTSB FTW90FA160Accident · 4 fatalField investigationFinal reportAerospatiale/Socata TB-10 · Ada, OKImproper planning/decision by the pilot, which resulted in his failure to attain sufficient airspeed for a climb profile. Factors related to the accident were: the pilot allowed the weight and balance of the aircraft to exceed the certified limits, his use of…NTSB SEA90FA165Accident · 4 fatalField investigationFinal reportPiper PA-30-160 · Kalispell, MTFailure of the pilot to flare the aircraft for landing and to maintain its control during the attempted go-around (aborted landing). Factors related to the accident were: darkness, a number of runway edge lights that were either inoperative or hidden by…NTSB NYC90LA198Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Norfolk, MAThe pilot in command's failure to maintain airspeed during an aborted landing resulting in an inadvertent stall and descent into trees.NTSB LAX90DUJ06Accident · 2 fatalFinal reportChristen/Walter Christen Eagle II · Marana, AZThe loss of control by the pilot.NTSB FTW90LA159Accident · No injuriesLimited investigationFinal reportCessna 182N · Justin, TXThe unexpected impairment of the pilot. Factors related to the accident were: the pilot's selection of a short grass runway with a tailwind, the high air temperature, and the obstructions (fence & power line) at the end of the runway.NTSB FTW90LA158Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Broken Arrow, OKThe pilot in command's failure to maintain directional control during the takeoff.NTSB DEN90FA172Accident · Serious injuriesField investigationFinal reportAerospatiale SA316B · Meeteetse, WYA main rotor head blade dampener failure. A factor in the accident was the subsequent failure of a blade restraining cable.NTSB DEN90DTE06Accident · Serious injuriesFinal reportCessna 188A · Holyoke, COA stall mush which occurred when the pilot retracted the flaps prematurely following takeoff, causing the aircraft to settle into the ground.NTSB DEN90DTE05Accident · No injuriesFinal reportCessna 188B · Eckley, COA failure on the part of the pilot in command to maintain adequate terrain clearance.NTSB BFO90DID01Accident · 2 fatalFinal reportCessna 172RG · Onancock, VAThe inflight loss of control because the pilot experienced spatial disorientation. Other factors related to the accident are VFR flight into IMC, night conditions.NTSB ANC90LA151Accident · Minor injuriesLimited investigationFinal reportArtic S1B2 · Talkeetna, AKThe pilot-in-command's failure to maintain air speed on takeoff.NTSB LAX90LA296Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Temecula, CAThe pilot's inadequate preflight that resulted in his continuing flight with an inoperative alternator.NTSB LAX90LA295Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Tucson, AZThe pilot to maintain proper pitch attitude and airspeed to avoid an aerodynamic stall.NTSB LAX90FA292Accident · 4 fatalField investigationFinal reportPiper PA-28RT-201 · Long Beach, CAThe inadequate visual outlook of the pilots of the Cessna 172P and their failure to see and avoid the Piper pa- 28RT-201. Contributing to the accident was the azimuth and angle of the sun which was in a position at the time of the accident to impair the scan…