NTSB investigations, 1980, IN
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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
Latest 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\") = 1980
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") = 1980 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 CHI81FA016Accident · 2 fatalClosedPiper PA-28R · Elkhart, INNTSB CHI81FEX06Accident · Serious injuriesClosedCessna 150H · Kokomo, INNTSB CHI81FA011Accident · 4 fatalClosedBeech E90 · Michigan City, INNTSB CHI81FA009Accident · 3 fatalClosedCessna 210H · Hagerstown, INNTSB CHI81FA007Accident · Serious injuriesClosedBeech V35A · Pimento, INNTSB CHI81FEX05Accident · No injuriesClosedCessna 152 · Noblesville, INNTSB CHI81FET02Accident · No injuriesClosedCessna 150 · Griffin, INNTSB CHI81DEX04Accident · No injuriesClosedBell 206B · Kokomo, INNTSB CHI81FEX03Accident · Minor injuriesClosedBeech F33A · Indianapolis, INNTSB CHI81DEX02Accident · Minor injuriesClosedPitts S-1C · Centerton, INNTSB CHI81FET01Accident · No injuriesClosedCessna 172 · Gary, INNTSB CHI81FEX01Accident · No injuriesClosedCessna 170 · Pendleton, INNTSB CHI80FEX37Accident · 1 fatalClosedPietenpol GN-1 · Marion, INNTSB CHI80DET03Accident · No injuriesClosedBede BD-5B · Goshen, INNTSB CHI80DET30Accident · No injuriesClosedCessna R182 · Roanoke, INNTSB CHI80FEX35Accident · No injuriesClosedBell 47G-4 · Carmel, INNTSB CHI81FET29Accident · No injuriesClosedBellanca 7ECA · Gary, INNTSB CHI80FEX34Accident · Minor injuriesClosedGrumman AA-5A · Jeffersonville, INNTSB CHI80FEX36Accident · No injuriesClosedCessna 172M · Brownsburg, INNTSB CHI80DEX33Accident · No injuriesClosedBeech E18S · Columbus, INNTSB CHI80FET27Accident · 1 fatalClosedDi Stasi Bowers · Ligonier, INNTSB CHI80FEX31Accident · No injuriesClosedHiller Acft UH-12E · Milan, INNTSB CHI80FET26Accident · No injuriesClosedPiper PA-32R · Syracuse, INNTSB CHI80DEX30Accident · No injuriesClosedGrumman AA-1B · Mooresville, INNTSB CHI80DEX32Accident · No injuriesClosedTaylorcraft F19 · Deer Creek, INNTSB CHI80FET25Accident · No injuriesClosedBeech A-35 · Hobart, INNTSB CHI80FET24Accident · No injuriesClosedGrumman G-164 · Howe, INNTSB CHI80FET23Accident · Minor injuriesClosedCessna 172M · Woodburn, INNTSB CHI80FA062Accident · 1 fatalClosedCessna 150 · Mishawaka, INNTSB CHI80FEX29Accident · No injuriesClosedHiller Acft UH-12E · Elrod, INNTSB CHI80DA061Accident · 1 fatalClosedAeronca C-3 · Luray, INNTSB CHI80FEX28Accident · No injuriesClosedGrumman AA-5A · Indianapolis, INNTSB CHI80FET22Accident · No injuriesClosedPiper PA-28 · Peru, INNTSB CHI80FEX25Accident · No injuriesClosedCessna 150F · Jeffersonville, INNTSB CHI80FET21Accident · 1 fatalClosedFaulkner MS-1 · Ft Wayne, INNTSB CHI80FEX27Accident · No injuriesClosedSchweizer SGS126 · Lafayette, INNTSB CHI80FEX26Accident · No injuriesClosedBeech C-23 · Martinsville, INNTSB CHI80FET20Accident · No injuriesClosedAeronca 65C · Ft.Wayne, INNTSB CHI80DEX24Accident · No injuriesClosedAeronca 7AC · Morristown, INNTSB CHI80DEX23Accident · No injuriesClosedCessna 188B · Saluda, INNTSB CHI80DEX22Accident · Minor injuriesClosedCessna 140A · E Enterprise, INNTSB DCA80AA020Accident · 3 fatalClosedLockheed 1049H · Columbus, INNTSB CHI80FEX21Accident · Minor injuriesClosedRand KR-1 · Sheridan, INNTSB CHI80FEX20Accident · No injuriesClosedCessna 172M · Bloomington, INNTSB CHI80FA046Accident · No injuriesClosedDouglas DC-6 · Indianapolis, INNTSB CHI80FA045Accident · 1 fatalClosedPiper PA32RT · South Bend, INNTSB CHI80FEX19Accident · Minor injuriesClosedBeech B-19 · Frankfort, INNTSB CHI80FEX17Accident · 1 fatalClosedGR Lakes X2T-1T · Lizton, INNTSB CHI80FEX16Accident · No injuriesClosedCessna 320E · Indianapolis, INNTSB CHI80DA037Accident · 1 fatalClosedCessna 172 · Nappanee, IN