NTSB investigations, 1992, IN
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 per year
| 1963 | 1 |
|---|---|
| 1964 | 107 |
| 1965 | 116 |
| 1966 | 119 |
| 1967 | 132 |
| 1968 | 106 |
| 1969 | 88 |
| 1970 | 83 |
| 1971 | 81 |
| 1972 | 88 |
| 1973 | 77 |
| 1974 | 66 |
| 1975 | 86 |
| 1976 | 78 |
| 1977 | 90 |
| 1978 | 95 |
| 1979 | 70 |
| 1980 | 76 |
| 1981 | 52 |
| 1982 | 55 |
| 1983 | 54 |
| 1984 | 55 |
| 1985 | 54 |
| 1986 | 58 |
| 1987 | 53 |
| 1988 | 66 |
| 1989 | 45 |
| 1990 | 42 |
| 1991 | 33 |
| 1992 | 29 |
| 1993 | 35 |
| 1994 | 38 |
| 1995 | 33 |
| 1996 | 31 |
| 1997 | 36 |
| 1998 | 35 |
| 1999 | 22 |
| 2000 | 34 |
| 2001 | 29 |
| 2002 | 25 |
| 2003 | 20 |
| 2004 | 26 |
| 2005 | 20 |
| 2006 | 28 |
| 2007 | 23 |
| 2008 | 22 |
| 2009 | 30 |
| 2010 | 27 |
| 2011 | 26 |
| 2012 | 26 |
| 2013 | 22 |
| 2014 | 16 |
| 2015 | 19 |
| 2016 | 23 |
| 2017 | 22 |
| 2018 | 19 |
| 2019 | 22 |
| 2020 | 17 |
| 2021 | 21 |
| 2022 | 21 |
| 2023 | 16 |
| 2024 | 17 |
| 2025 | 13 |
| 2026 | 9 |
Where
Open the mapLatest cases
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
AND c.\"eventStateOrRegion\" = 'IN' AND c.\"eventCountry\" = 'USA'
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 AND c."eventStateOrRegion" = 'IN' AND c."eventCountry" = 'USA' 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 CHI93LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Kokomo, INFailure to maintain aircraft control, and spatial disorientation of the pilot.NTSB CHI93DET01Accident · No injuriesFinal reportCarlson Sparrow II · Lafontaine, INFuel starvation due to a blocked fuel line which was caused by improper gasket sealing compound.NTSB CHI93LA021Accident · No injuriesLimited investigationFinal reportCessna C177B · Noblesville, INThe pilot's improper recovery from a bounced landing.NTSB CHI93LA003Accident · No injuriesLimited investigationFinal reportCessna 172P · Kokomo, INThe pilot's delayed remedial action.NTSB DCA92MA049Accident · 6 fatalClass 1 · MajorFinal reportMitsubishi MU-2B-60 · Greenwood, INThe inherent limitations of the see-and-avoid concept of separation of aircraft operating under visual flight rules that precluded the pilots of the MU-2 and the PA-32 from recognizing a collision hazard and taking actions to avoid the midair collision.…NTSB CHI92LA271Accident · No injuriesLimited investigationFinal reportCessna 152 · Scotland, INThe pilot's delay in aborting a takeoff attempt after failing to attain flying speed during a takeoff ground run.NTSB CHI92LA269Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Gary, INThe pilot's failure to land at the proper touchdown point on the runway and landing with excessive airspeed.NTSB CHI92FA267Accident · 1 fatalField investigationFinal reportPiper PA-61-601P · Aurora, INExceeding the design stress limits of the airplane by the pilot in command.NTSB CHI92LA264Accident · No injuriesLimited investigationFinal reportCessna 170A · Angola, INFailure of the pilot to maintain directional control during landing rollout.NTSB CHI92LA261Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Wayne, INThe pilot's failure to maintain directional control during the landing roll.NTSB CHI92LA249Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Marshall, INThe pilot's failure to maintain control of the helicopter due to his alcoholic impairment of efficiency and judgement.NTSB CHI92LA245Accident · No injuriesLimited investigationFinal reportCessna 182A · Colfax, INThe pilot's selection of the wrong runway and a premature lift off. Factors were uphill terrain and unfavorable (quartering/tail) wind.NTSB CHI92DET01Accident · Serious injuriesFinal reportFrost Briegleb/BG-12A · Lake Village, INInadvertent stall and spin with inadequate altitude for recovery.NTSB CHI92DEX04Accident · Minor injuriesFinal reportAlkire Pietenpol · Delphi, INSeparation of the propeller while in flight, and unsuitable terrain to effect a forced landing.NTSB CHI92DEX03Accident · 1 fatalFinal reportPiper PA-25-260 · Decker, INFailure of the right wing spar, improper maintenance/modification, and failure to comply with an airworthiness directive.NTSB CHI92DEX02Accident · No injuriesFinal reportTownsend-Snyder Rultan Varieze · Indianapolis, INFuel starvation due to improper fuel tank selection.NTSB CHI92LA208Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Kendallville, INImproper remedial action, the pilot's failure to maintain airspeed, and the failed tow rope.NTSB CHI92LA184Accident · No injuriesLimited investigationFinal reportCessna 150L · Evansville, INThe pilot's misjudgement of fuel supply.NTSB CHI92LA157Accident · No injuriesLimited investigationFinal reportCessna 150 · South Bend, INImproper aircraft control by the pilot.NTSB CHI92DEX01Accident · No injuriesFinal reportJames D. Bierly VARI-EZ · Jeffersonville, INA collapsed carburetor air intake duct. Factors related to the accident were soft, unsuitable terrain on which to make a forced landing.NTSB CHI92LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Hanover, INInadequate remedial action by the pilot in command when the engine lost partial power during cruise flight. Factors in the accident were the presence of carburetor icing conditions, and soft terrain in the area selected for a forced landing.NTSB CHI92LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INThe student pilot's failure to maintain directional control and his delaying the aborted landing.NTSB CHI92LA106Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Elkhart, INProper glidepath was not maintained and minimum descent altitude was not maintained by the pilot resulting in collision with trees. Factors relate to the accident were the pilot's lack of total experience in type of operation and over confidence in personal…NTSB CHI92LA093Accident · No injuriesLimited investigationFinal reportCessna 182B · Auburn, INThe improper maintenance and adjustment of the carburetor by other maintenance personnel.NTSB CHI92LA094Accident · No injuriesLimited investigationFinal reportCessna T210M · Washington, INThe total loss of engine power due to a fatigue-fractured crankshaft.NTSB CHI92LA090Accident · No injuriesLimited investigationFinal reportCessna 414 · Logansport, INThe pilot's failure to maintain an adequate approach speed which resulted in an improper flare. Factors contributing to the accident were the inadequate inflight deicing of the airframe surfaces and in icing conditions encountered.NTSB CHI92LA073Accident · No injuriesLimited investigationFinal reportCessna 177RG · Indianapolis, INEngine loss of power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.NTSB CHI92LA072Accident · No injuriesLimited investigationFinal reportBeech A36 · Griffith, INPremature gear retraction during takeoff roll by the pilot.NTSB CHI92IA068Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-ATP · Fort Wayne, INFailure of company maintenance personnel to maintain the airplane in accordance with existing service bulletins.