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 LAX91TL#01Accident · No injuriesClass 3Final reportMcDonnell Douglas 369E · Los Alamitos, CANTSB ATL91FA015Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Rock Hill, SCThe pilot misjudged the aircraft's altitude/clearance above the runway during a low pass and allowed the propeller to contact the runway; he then failed to maintain airspeed after a pull-up and allowed the aircraft to stall.NTSB ANC91LA010Accident · No injuriesLimited investigationFinal reportCessna 182N · Chugiak, AKThe pilot failed to maintain directional control. Contributing to the accident was the gusty crosswinds and slippery runway.NTSB SEA91LA012Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Afton, WYAn improper maintenance modification to disable the carburetor heat control by unknown personnel.NTSB NYC91LA024Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Buckland, MAThe pilot's failure to execute an aerobatic maneuver at an altitude sufficient to clear the stand of trees.NTSB MIA91LA021Accident · No injuriesLimited investigationFinal reportCessna 170 · Patillas, PRThe accident was failure of the non certificated pilot to lower the flaps to the correct position for takeoff and failure to abort the takeoff due to insufficient acceleration.NTSB LAX91LA030Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Portal, AZFailure of the pilot to maintain proper altitude.NTSB CHI91LA024Accident · No injuriesLimited investigationFinal reportCessna 180 · Northwood, NDPoor in-flight planning and decision, unsuitable terrain selected by the PIC.NTSB CHI91DEP01Accident · No injuriesFinal reportDean Bartel Avid Flyer Stol · New London, WIThe pilot's failure to obtain a proper touchdown point and his delay in initiating a go-around.NTSB BFO91LA010Accident · No injuriesLimited investigationFinal reportAeronca L3B · Farmville, VAThe failure of the pilot to properly secure the aircraft while starting the engine by hand proping.NTSB ANC91LA009Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot-in-command's failure to maintain directional control of the airplane during the landing roll.NTSB NYC91LA023Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Elyria, OHThe loss of engine power for an undetermined reason(s).NTSB NYC91DNC02Accident · Serious injuriesFinal reportMarier Early Bird Jenny · Concord, NHThe failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall spin. A factor related to the accident was: the pilot's lack of experience in the make and model of aircraft.NTSB MIA91FA020Accident · 2 fatalField investigationFinal reportAero Commander 680V · Fort Lauderdale, FLThe pilot-in-command's decision to continue takeoff with a known deficiency in the airplane - low power on both engines which resulted from open compressor surge valves. The pilot subsequently failed to maintain airspeed while maneuvering in a turn resulting…NTSB LAX91LA023Accident · No injuriesLimited investigationFinal reportCessna 150G · Columbia, CAPoor planning which resulted in fuel exhaustion.NTSB CHI91LA023Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Scott, KSThe mixture control was set incorrectly resulting in fuel starvation, and the check list was not followed by the cfi/pic.NTSB CHI91DEM01Accident · 1 fatalFinal reportErcoupe 415C · Shelby, MIThe pilot's continued flight into IMC.NTSB CHI91DEE01Accident · 1 fatalFinal reportPitts Special S1-S · Dekalb, ILThe pilot's attempt to perform aerobatic maneuvers at low altitude.NTSB BFO91LA009Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Elkton, VAThe pilot's failure to use carburetor heat which resulted in a reduction in engine power. A factor was the rough terrain.NTSB ATL91IA014Incident · No injuriesIncident investigationFinal reportBell 412 · Knoxville, TNThe pilot's failure to see and avoid the wires prior to the collision. Factors in the incident were the failure of the ground personnel to adequately inspect the landing zone, the presence of high intensity lights at the lz, and the dark lighting conditions.NTSB FTW91LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Abilene, TXPilot's failure to compensate for gusty wind condition.NTSB FTW91DPD01Accident · No injuriesFinal reportRans S-9 · Iowa Park, TXThe total loss of engine power due to fuel starvation as the result of a blocked fuel filter in the fuel system.NTSB NYC91LA022Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Sherburne, NYThe pilot failed to maintain adequate altitude to outclimb surrounding terrain.NTSB LAX91LA021Accident · No injuriesLimited investigationFinal reportCessna 152 · Maricopa, AZThe failure of the flight instructor to ensure that an adequate airspeed was maintained during the final approach for the existing wind conditions; to adequately supervise the conduct of the flight; and to arrest the rate of descent prior to touch down.NTSB LAX91FA020Accident · 2 fatalField investigationFinal reportGrumman AA-1B · Solana Beach, CAThe inadvertent stall/spin. Factors in the accident were: the pilot's decision to allow the reporter passenger to fly the aircraft in a critical flight situation, his decision to allow the aircraft to descend to an altitude too low to allow for contingencies,…NTSB BFO91T#001Incident · No injuriesFinal reportLockheed 188C · Wallops Island, VANTSB ATL91FA013Accident · Serious injuriesField investigationFinal reportBell 47J-2 · Gatlinburg, TNThe accident was inadequate maintenance of the helicopter, allowing a tail rotor drive shaft bearing to exceed wear limits. This resulted in high loads on the tail rotor drive shaft, and the resulting fatigue failure of the drive shaft.NTSB MIA91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Osteen, FLTotal loss of engine power, for an undetermined reason.NTSB DEN91LA015Accident · No injuriesLimited investigationFinal reportCessna 182C · Silver City, NMThe pilot's improper planning which resulted in fuel starvation.NTSB CHI91FA022Accident · 2 fatalField investigationFinal reportCessna 195 · Flint, MIThe pilot-in-command's inadequate preflight inspection of the fuel tank system. Factor(s) were: water contamination in the fuel.NTSB MIA91FA017Accident · 1 fatalField investigationFinal reportCessna 150G · Marathon, FLThe pilot-in-command's failure to maintain airspeed, while attempting to make a forced landing following a partial loss of engine power. Fatigue failure of the center rocker boss on the #3 cylinder was a related factor.NTSB LAX91LA019Accident · No injuriesLimited investigationFinal reportCessna 172M · Torrance, CAThe student pilot failed to properly flare the airplane, made an improper recovery from the subsequent bounced landing. Contributing to this accident was the student pilot's total lack of experience and his improper use of the rudder.NTSB CHI91LA019Accident · No injuriesLimited investigationFinal reportCessna 150 · La Crosse, WIInadequate visual outlook by the PIC.NTSB BFO91FA008Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · Elkton, MDLoss of engine power for an undetermined reason, and the pilot's failure to maintain adequate airspeed, which resulted in a stall and an inflight collision with the terrain.NTSB NYC91LA021Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-31 · Columbus, OHFailure by pilots of the other aircraft to see and alter taxi path to avoid the standing aircraft.NTSB LAX91FA022Accident · 3 fatalField investigationFinal reportPiper PA-22-108 · Oceanside, CAThe pilot initiating an instrument flight without operating air/ground communications equipment, and his failure to maintain adequate terrain clearance after apparently deciding to return to the airport. Factors contributing to the accident were inoperative…NTSB DEN91LA014Accident · Minor injuriesLimited investigationFinal reportCessna T-210-M · Buena Vista, COThe pilot misjudged the fuel supply resulting in fuel exhaustion.NTSB ATL91LA012Accident · No injuriesLimited investigationFinal reportCessna 150M · Williamston, NCThe student pilot's failure to properly flare the airplane during the night landing attempt. The pilot's failure to maintain geographic orientation and the subsequent flight into night conditions were factors in the accident. The pilot's lack of night flying…NTSB SEA91LA009Accident · No injuriesLimited investigationFinal reportCessna T210N · Laramie, WYThe pilot did not properly set the mixture control.NTSB NYC91LA020Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 50 · Parkersburg, WVCatastrophic failure of the left engine fan disc due to low cycle fatigue.NTSB NYC91LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Columbia, PAThe failure of the pilot to maintain a proper altitude on final approach and compensate for the headwind. A factor to the accident was the failure of the pilot to recognize his low altitude and execute a go-around.NTSB CHI91LA020Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180D · Crivitz, WIImproper planning/decision by the pilot, and his failure to abort the takeoff (while there was sufficient runway remaining).NTSB CHI91LA018Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Greenfield, INA stall/spin encountered due to an improper go-around.NTSB SEA91LA011Accident · No injuriesLimited investigationFinal reportCessna 172G · Anacortes, WAThe pilot poorly compensated for the wind condition.NTSB SEA91LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Blackfoot, IDThe pilot did not adequately recover from a bounced landing. Factors were improper airspeed and lack of total expereince.NTSB NYC91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Bally, PAThe pilot's improper recovery from a bounced landing and his failiure to maintain directional control.NTSB CHI91LA017Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Portage, WIThe PIC became lost and disorientated and performed a premature precautionary landing.NTSB BFO91LA007Accident · No injuriesLimited investigationFinal reportCessna 185 · Ridgely, MDThe loss of engine power for undetermined reasons.NTSB FTW91FA010Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Kingsland, TXThe pilot's failure to avoid flying into the mountain.NTSB DEN91FA013Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Belen, NMThe pilot misjudged the aircraft's altitude (ground clearance) above the desert terrain.