NTSB investigations, 1992
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\") = 1992 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") = 1992 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 DEN93LA006Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Grand Junction, COFatigue failure of the nose landing gear upper drag strut bracket due to fatigue cracking.NTSB ATL93LA014Accident · Minor injuriesLimited investigationFinal reportBeech A23A · Cumming, GAThe pilot's failure to use the fuel boost pump when the engine malfunctioned during take off.NTSB ATL93LA013Accident · No injuriesLimited investigationFinal reportPatrick F. Bowers Corbin JR. ACE E · Woodstock, GAThe separation of the propeller from the aircraft.NTSB NYC93LA033Accident · No injuriesLimited investigationFinal reportCessna 172N II · Waverly, OHAn unavoidable collision with a deer.NTSB NYC93LA023Accident · No injuriesLimited investigationFinal reportCessna C-152 · Petersham, MAThe imprpoer maintenance procedures which resulted in engine failure and subsequent forced landing on unsuitable terrain.NTSB MIA93LA007Accident · No injuriesLimited investigationFinal reportCessna 152 · Hollywood, FLThe pilot in command's improper flare which resulted in the aircraft ballooning during landing, followed by his improper recovery from the ballooned landing which resulted in the aircraft touching down hard on the nose landing gear causing it to collapse.NTSB LAX93LA013Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CAThe pilot's inadequate planned approach to the runway, and, his improper use of the flight controls which resulted in an inadvertent accelerated stall/spin.NTSB FTW93LA016Accident · No injuriesLimited investigationFinal reportVuncannon Rotorway R162 · Wynne, ARLift degradation on one main rotor blade surface due to a foreign object.NTSB ATL93FA012Accident · 2 fatalField investigationFinal reportPiper PA-12 · Cedar Springs, GAThe private pilot's failure to maintain airspeed above stalling speed, and his failure to maintain a proper altitude, which resulted in an inadvertent, low altitude stall. A factor was the gusty wind condition at the time of the accident.NTSB ANC93LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Seward, AKThe pilots failure to maintain directional control on the ground. Contributing to the accident was the pilots failure to maintain airspeed during the takeoff climb, his inadequate training, his lack of total experience, and the ditch.NTSB CHI93LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Saline, MIThe pilot's failure to maintain aircraft control and airspeed.NTSB NYC93LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Newburyport, MAThe pilot's inaccurate fuel consumption calculations and improper preflight planning, resulting in fuel exhaustion.NTSB FTW93T#A01Accident · No injuriesFinal reportHiller UH-12B · Anahuac, TXNTSB FTW93LA015Accident · No injuriesLimited investigationFinal reportRobinson R22B · Robert Lee, TXThe loss of engine/rotor RPM for undetermined reasons.NTSB FTW93LA013Accident · Minor injuriesLimited investigationFinal reportBeech V35E · Laguna, NMFailure of the pilot to select the proper fuel tank and resultant fuel starvation power loss. A factor was the unsuitable terrain.NTSB ATL93LA011Accident · No injuriesLimited investigationFinal reportCessna 172RG · Clarksville, TNThe fracture of the section gear in the main landing gear retraction and extension mechanism.NTSB LAX93LA012Accident · 2 fatalLimited investigationFinal reportGilbert SX300 · Rosamond, CAThe pilots inadequate compensation for the wind conditions and his failure to maintain an adequate airspeed while maneuvering which led to an inadvertent stall spin.NTSB FTW93LA012Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Mexia, TXThe pilot fueled the aircraft with jet fuel instead of avaition gasoline. Factors were the unsuitable terrain encountered during the forced landing and the dark night light conditions.NTSB NYC93LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Grove City, PAThe pilot raised the flaps prematurely, resulting in an inadvertent stall at to low an altitude to allow recovery.NTSB MIA93LA006Accident · 1 fatalLimited investigationFinal reportHarkness, Richard W. Adventure · New Smyrna Bch, FLThe failure of the pilot in command to maintain airspeed above stall speed following engine failure resulting in the aircraft stalling and descending uncontrolled to the ground. Contributing to the accident was the pilot in command's improper leaning of the…NTSB LAX93FA011Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Rosemead, CAThe pilot's poor preflight planning/preparation and intentional flight into instrument meteorological conditions. Factors relating to this accident were the prevailing low ceiling and fog.NTSB DEN93IA005Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COAn inadvertent attempt, by unknown persons, to start the APU which had been placarded as inoperative. Factors were: inadequate procedures in rendering the APU incapable of being started when inoperative.NTSB CHI93LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Hillsdale, MIInadequate preflight planning in not refueling the aircraft and a poorly planned forced landing by the pilot.NTSB NYC93IA017Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Pittsburgh, PAThe high cycle fatigue failure of blades on the stage 1 high pressure compressor, which resulted in blade fracture and subsequent internal engine damage and fire.NTSB NYC93FA015Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Elkton, VAThe pilot's delay in aborting the landing which resulted in insufficient runway remaining to allow the airplane to reach sufficient altitude to clear the obstacles at the end of the runwayNTSB ATL93FA008Accident · 4 fatalField investigationFinal reportCessna 310K · East Point, GAThe pilot's mismanagement of the fuel supply which resulted in fuel stravation of both engines.NTSB ANC93FA067Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Talkeetna, AKThe pilot's continued visual flight into instrument meteorological conditions at night which resulted in a loss of airplane control, spatial disorientation, and an inflight breakup. Factors which contributed to the accident were: the adverse weather and the…NTSB SEA93LA008Accident · No injuriesLimited investigationFinal reportJames R. Prideaux Avid Flyer · Mt. Home, IDDirectional control was not maintained. A factor to the accident was: a tail wind.NTSB SEA93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Spokane, WAInadequate preflight planning/preparation. Factors to the accident were: fuel exhaustion and inadequate fuel consumption calculations.NTSB NYC93LA016Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Kitts Hill, OHA hard landing due to improper use of the collective, following a wire strike due to inadequate visual lookout.NTSB LAX93LA010Accident · No injuriesLimited investigationFinal reportBell 47-D1 · El Monte, CAThe pilot's failure to maintain the rotor RPM.NTSB LAX93LA009Accident · No injuriesLimited investigationFinal reportCessna 210F · Buena Park, CAFailure of the pilot to adequately detect water contamination in the airplane's fuel system during preflight.NTSB LAX93FA007Accident · 1 fatalField investigationFinal reportCessna 172M · Fairfield, CAThe pilot's delay in initiating a go-around during a night landing. Factors related to the accident were: the pilot misjudging distance and speed resulting a overshooting the touchdown, the night light condition, his lack of night flying experience in a…NTSB FTW93LA011Accident · No injuriesLimited investigationFinal reportCessna L-19A · Brookshire, TXThe pilot's improper compensation for the cross wind. A factor was the crosswind.NTSB CHI93LA008Accident · No injuriesLimited investigationFinal reportCessna 150M · Romeo, MIInadequate compensation for wind conditions by the pilot in command and failure to attain directional control of the airplane during landing flare and touchdown.NTSB NYC93LA014Accident · No injuriesLimited investigationFinal reportPiper PA28-161 · St. Clairsville, OHThe pilot's improper in-flight planning and decision to land on a short grass runway with a tail wind. A factor in this accident was the pilots failure to obtain and evaluate a weather briefing prior to the flight.NTSB NYC93FA013Accident · 1 fatalField investigationFinal reportCessna 195 · Shenandoah, PAA loss of control due to pilot incapacitation.NTSB LAX93LA008Accident · No injuriesLimited investigationFinal reportCessna R172K · Picacho, AZThe pilot's encounter with the unforecasted cyclonic wind.NTSB DEN93LA004Accident · No injuriesLimited investigationFinal reportCessna 172N · Addison, TXThe attempt by both pilots to pass each other without adequate clearance between their airplanes.NTSB DEN93LA003Accident · Serious injuriesLimited investigationFinal reportO'Connor SNO-BIRD XL · Bryan, TXDelamination of the rudder leading edge and subsequent jamming of the rudder.NTSB ATL93LA007Accident · 1 fatalLimited investigationFinal reportBensen B-8M · Holly Ridge, NCThe pilot's failure to operate the flight controls properly.NTSB NYC93FA012Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Pulaski, VAThe improper decision by the non-instrument-rated pilot to continue VFR flight into known instrument meteorological conditions resulting in spatial disorientation and loss of control of the airplane. Factors which contributed to the accident were the actions…NTSB LAX93LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Quartzsite, AZEngine failure for an undetermined reason. Contributing to this accident was the rough/uneven terrain.NTSB ATL93LA009Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Centre, ALThe pilot's failure to maintain main rotor RPM, which resulted in an in flight loss of control and collision with terrain.NTSB ANC93FA148Accident · 1 fatalField investigationFinal reportChampion 7EC · Chugiak, AKCollision with the terrain for an unknown reason.NTSB NYC93LA011Accident · Serious injuriesLimited investigationFinal reportAnderson Pitts S-1 · Minersville, PAA loss of control due to a foreign object jamming the elevator flight controls.NTSB NYC93LA009Accident · No injuriesLimited investigationFinal reportAeronca 11-AC · Columbus, OHThe pilot failed to maintain control of the airplane, resulting the airplane departing the runway and impacted with the VASI lights.NTSB FTW93LA010Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Albuquerque, NMThe pilot's failure to maintain visual lookout.NTSB FTW93FA008Accident · 1 fatalField investigationFinal reportBeech 95-B55B · Chatham, LAThe inadvertent stall and spin. Factors were the power loss due to fuel starvation, the dark night, and his failure to use the boost pump for engine restart.NTSB CHI93LA007Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Wichita, KSInadequate preflight planning/preparation by the pilot, the pilot's over confidence in his personal ability, and airplane performance data not followed by the pilot.