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 CHI93LA023Accident · No injuriesLimited investigationFinal reportCessna 140 · Waverly, IAThe pilot's excessive application of brakes during landing roll.NTSB CHI93LA022Accident · No injuriesLimited investigationFinal reportCessna 172N · Ankeny, IAThe pilot's improper recovery for a bounced landing.NTSB ATL93FA016Accident · 2 fatalField investigationFinal reportGrumman American AA-5 · Snow Hill, NCThe pilot's failure to use carburetor heat, which resulted in loss of engine power. Factors were the carburetor icing conditions, and the dark night lighting conditions.NTSB FTW93LA024Accident · No injuriesLimited investigationFinal reportCessna 150M · Norman, OKThe pilot's failure to properly judge his level off altitude while maneuvering.NTSB FTW93LA023Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Hillsboro, TXFuel exhaustion engine power loss due to the pilot's failure to refuel. A factor was the lack of suitable terrain available for the forced landing.NTSB SEA93FA010Accident · 2 fatalField investigationFinal reportPiper PA-12 · Lowman, IDThe pilot's failure to maintain adequate terrain clearance. Factors include mountainous/hilly terrain, trees, and the pilot's diverted attention.NTSB NYC93LA030Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Monroeville, PAThe pilot's improper compensation for adverse wind conditions during landing, resulting in a loss of directional control and subsequent departure from the runway and collision with trees. Factor related to the accident was: the unfavorable winds.NTSB MIA93LA012Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Pierce, FLAn engine failure over unsuitable terrain. The cause of the engine failure was fuel contamination by ferrous metal particles that prevented the fuel servo from operating properly. The origin of the contamination is unknown.NTSB CHI93LA020Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Carroll, IAThe pilot's failure to maintain aircraft directional control while landing in crosswind conditions.NTSB CHI93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Ludington, MIThe partial loss of engine power during the initial climb out on a night flight.NTSB CHI93LA015Accident · No injuriesLimited investigationFinal reportBeech K35 · Scott City, KSFailure of the alternator and the pilot's inadvertent descent.NTSB ATL93LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Knoxville, TNThe pilots poor inflight decision to attempt to land the aircraft in an unsuitable area.NTSB SEA93LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Enterprise, ORPoor in-flight planning/preparation. A factor to the accident was: improper use of the mixture.NTSB MIA93LA011Accident · 1 fatalLimited investigationFinal reportHunter Velocity · Apopka, FLAn encounter with wake turbulence from a Boeing 727.NTSB LAX93LA018Accident · No injuriesLimited investigationFinal reportCessna 305A · Prescott, AZThe pilot not maintaining directional control during landing roll resulting in a ground loop swerve.NTSB FTW93LA022Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Commerce, TXThe pilot's failure to maintain aircraft control and the inadvertent stall. A factor was the pilot's evasive maneuver to avoid an undetermined object.NTSB DEN93LA007Accident · 1 fatalLimited investigationFinal reportMarcy Kitfox IV · Longmont, COAn inadvertent stall. A factor was: the pilot's lack of familiarity with the airplane.NTSB DEN93FA008Accident · 1 fatalField investigationFinal reportCessna 172P · Woody Creek, COAircraft climb performance exceeded. Factors were: the pilot's lack of experience in mountain flying, and the high density altitude conditions.NTSB CHI93LA017Accident · 1 fatalLimited investigationFinal reportPiper PA-25-260 · Trenton, NDThe pilot's improper aircraft handling while maneuvering at low altitude.NTSB SEA93LA009Accident · Minor injuriesLimited investigationFinal reportMorrisey Shinn 2150A · Dallas, ORFailure to maintain airspeed. Factors include an improper fuel selector setting, and fuel starvation.NTSB MIA93WA010Accident · No injuriesForeign investigationCessna T188C · Cozumel, MexicoNTSB LAX93LA017Accident · 1 fatalLimited investigationFinal reportPasporello, J.F. RV-3 · Lompoc, CAThe failure of an unidentified airframe or component system for unknown reasons and the resulting inflight fire.NTSB CHI93LA018Accident · 1 fatalLimited investigationFinal reportAmerican Eagle 101 · New Hudson, MIThe pilot's failure to maintain aircraft control.NTSB ATL93LA017Accident · No injuriesLimited investigationFinal reportCessna 150 · Powell, TNThe water in the aircraft fuel as a result of the improper preflight by the pilot.NTSB ANC93LA009Accident · No injuriesLimited investigationFinal reportCessna 206 · Slate Creek, AKThe icy condition of the runway and the discontinued snow removal.NTSB NYC93LA029Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Great Barrington, MAThe inadequate pre-flight by the pilot ensuring fuel cap security. A factor in this accident was the pilots complacency in fuel management.NTSB FTW93LA021Accident · No injuriesLimited investigationFinal reportCessna 177B · Las Cruces, NMThe pilot's delayed landing flare and the improper bounced landing recovery. A factor was the dark night.NTSB CHI93LA021Accident · No injuriesLimited investigationFinal reportCessna C177B · Noblesville, INThe pilot's improper recovery from a bounced landing.NTSB CHI93LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Weeping Water, NEThe pilot's failure to maintain directional control.NTSB CHI93LA013Accident · No injuriesLimited investigationFinal reportSchweizer H-300 · Grand Forks, NDThe pilot's failure to maintain control of the helicopter during a night landing.NTSB CHI93IA019Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Chicago, ILThe failure of the midway arsa controller to coordinate use of the airspace with the Chicago north local controller which resulted in an operational deviation. A factor related to the incident was the pilot's failure to follow his assigned heading.NTSB CHI93DTG01Accident · No injuriesFinal reportKing BOWERS-FLYBABY · Buffalo, NDPartial loss of engine power due to improper installation of the carburetor, by the pilot/owner.NTSB MIA93FA009Accident · 1 fatalField investigationFinal reportCessna 152 · New Port Richey, FLLoss of control inflight by the pilot for undetermined reasons.NTSB LAX93LA016Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Globe, AZMaintenance personnel failing to comply with airworthiness directives pertaining to the airplane's fuel bladders resulting in fuel capacity being decreased causing fuel exhaustion and subsequent loss of engine power.NTSB FTW93LA020Accident · No injuriesLimited investigationFinal reportBritish Aerospace 3100 · Dfw Airport, TXThe pilot's failure to maintain visual lookout and clearance. The congested ramp was a factor.NTSB FTW93LA019Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-32 · Houston, TXThe vehicle operator's failure to maintain an adequate visual lookout.NTSB CHI93LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Maryland Height, MOBlockage of the induction air system by a mouse nest.NTSB SEA93LA006Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Sisters, ORThe pilot's poor inflight decision. Factors include mountainous/hilly terrain, trees, high density altitude, and downdrafts.NTSB NYC93LA027Accident · No injuriesLimited investigationFinal reportCessna 177 · Morgantown, WVThe pilot's improper preflight and planning, which resulted in fuel exhaustion and a forced landing on a highway.NTSB NYC93FA028Accident · 2 fatalField investigationFinal reportBeech A36 · Middlebourne, WVThe pilot's decision to intentionally fly into known icing conditions which resulted in an inadvertent stall and uncontrolled descent into trees. A factor related to the accident was the icing conditions.NTSB MIA93WA008Accident · No injuriesForeign investigationCessna 172M · Mayaguana Isl, BahamasNTSB FTW93WA018Accident · No injuriesForeign investigationGulfstream 680 T · Pesqueria, MexicoNTSB NYC93LA021Accident · No injuriesLimited investigationFinal reportCessna 210L · Cincinnati, OHThe failure of the pilot to maintain directional control during landing which resulted in the airplane striking a drainage ditch. Factors related to the accident were the crosswind and the drainage ditch.NTSB NYC93GA025Accident · Serious injuriesFinal reportSchweizer 269C · Baltimore, MDA power loss of undetermined origin. Factors related to the accident were the night conditions, the lack of a suitable landing area, and the inability of the pilot to maintain rotor RPM while maneuvering to avoid obstacles.NTSB NYC93FA026Accident · 2 fatalField investigationFinal reportBeech 55 · Leicester, MAThe failure of the pilot to maintain the proper glide path. Factors related to the accident were the pilot's lack of recent flight experience and his lack of recent instrument experienced.NTSB FTW93FA017Accident · 1 fatalField investigationFinal reportCessna 150L · Liverpool, TXThe pilot's failure to maintain clearance with the obstruction. Factors were: the pilot's lack of total experience in night operations, and inadequate supervision from the certified flight instructor.NTSB NYC93LA024Accident · No injuriesLimited investigationFinal reportCessna 150L · Linden, NJThe automobile driver's failure to see and avoid aircraft traffic while crossing an active runway.NTSB NYC93LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Princeton, NJThe pilot failed to maintain control of the airplane, resulting in the airplane departing the runway, impacting with a wall and subsequently caught fire. A contributing factor was the pilot improperly compensated for a crosswind.NTSB LAX93FA014Accident · Serious injuriesField investigationFinal reportCessna T337G · Fullerton, CAThe pilot's failure to maintain control of the aircraft during a circle to land maneuver in reduced visibility conditions. A factor in the accident was his distraction while reconfiguring the aircraft for a go around which led to an inadvertent entry into a…NTSB DEN93LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Colorado Spring, COProper descent rate was not maintained by the pilot in command which resulted in a hard landing.