NTSB investigations, 1964, 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
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\") = 1964
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") = 1964 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 UNK65X1114Accident · No injuriesClosedMaule M4 · Zionsville, INNTSB UNK65X1062Accident · No injuriesClosedPiper PA28 · Lisbon, INNTSB UNK65X1058Accident · Serious injuriesClosedPiper PA24 · Indianapolis, INNTSB UNK65X1014Accident · No injuriesClosedBeechraft F35 · Frankfort, INNTSB UNK65X0936Accident · No injuriesClosedPiper PA22 · Windfall, INNTSB UNK65X0935Accident · No injuriesClosedPiper PA24 · Bedford, INNTSB UNK65X0933Accident · No injuriesClosedPiper PA28 · Hobart, INNTSB UNK65X0847Accident · No injuriesClosedSmith DSA1 · Linton, INNTSB UNK65X0765Accident · No injuriesClosedPiper PA24 · Michigan City, INNTSB UNK65X0704Accident · No injuriesClosedLuscombe 8A · Elkhart, INNTSB UNK65X0629Accident · No injuriesClosedCessna 310 · South Bend, INNTSB UNK65X0531Accident · No injuriesClosedMooney 20C · Indianapolis, INNTSB UNK65X0521Accident · No injuriesClosedPiper PA28 · Kendallville, INNTSB UNK65X0466Accident · Serious injuriesClosedCessna 150 · Schneider, INNTSB UNK65X0425Accident · Minor injuriesClosedNavion A · Bloomington, INNTSB UNK65X0373Accident · No injuriesClosedPiper PA16 · Indianapolis, INNTSB UNK65X0349Accident · No injuriesClosedBeechcraft E35 · Ft Wayne, INNTSB UNK65X0235Accident · Minor injuriesClosedTaylorcraft BC123 · Markle, INNTSB UNK65X0203Accident · No injuriesClosedBellanca 1413 · Hartford City, INNTSB UNK65X0137Accident · No injuriesClosedPiper PA28 · Hobart, INNTSB UNK65X0127Accident · No injuriesClosedPiper PA28 · Franklin, INNTSB UNK64X4149Accident · Serious injuriesClosedCessna 175 · Culver, INNTSB UNK64X4080Accident · Serious injuriesClosedCommonwealt H185 · Fortville, INNTSB UNK64X4075Accident · No injuriesClosedMooney M20B · Logansport, INNTSB UNK64X4029Incident · No injuriesClosedDouglas DC-3 · Indianapolis, INNTSB UNK64X3968Accident · No injuriesClosedCessna 182E · Greenfield, INNTSB UNK64X3893Accident · No injuriesClosedErcoupe 415C · Anderson, INNTSB UNK64X3867Accident · No injuriesClosedBeechcraft C18 · Brownsburg, INNTSB UNK64X3862Accident · No injuriesClosedCessna 120 · South Bend, INNTSB UNK64X3855Accident · No injuriesClosedCessna 182 · Griffith, INNTSB UNK64X3851Accident · No injuriesClosedBellanca 14132 · Valparaiso, INNTSB UNK64X3850Accident · No injuriesClosedMaule M4 · Ft Wayne, INNTSB UNK64X3803Accident · 1 fatalClosedErcoupe 415C · Columbus, INNTSB UNK64X3792Accident · No injuriesClosedPiper PA30 · Muncie, INNTSB UNK64X3734Accident · No injuriesClosedBeechcraft D18 · Marion, INNTSB UNK64X3710Accident · No injuriesClosedSwift GC1B · Tipton, INNTSB UNK64X3649Accident · No injuriesClosedNo American TF51D · Laporte, INNTSB UNK64X3646Accident · No injuriesClosedNavion G · Rushville, INNTSB UNK64X3624Accident · No injuriesClosedCessna 172 · Lafayette, INNTSB UNK64X3605Accident · No injuriesClosedStinson 108-3 · Gary, INNTSB UNK64X3570Accident · Serious injuriesClosedCessna 170A · Paoli, INNTSB UNK64X3511Accident · No injuriesClosedPiper PA28 · Noblesville, INNTSB UNK64X3467Accident · No injuriesClosedBeechcraft H35 · Bronnsburg, INNTSB UNK64X3447Accident · No injuriesClosedPiper PA22 · Marion, INNTSB UNK64X3390Accident · No injuriesClosedPiper J3 · Linn Grove, INNTSB UNK64X3244Accident · Minor injuriesClosedBrantly B2B · Borden, INNTSB UNK64X3199Accident · No injuriesClosedSchweizer 222E · Jefferson, INNTSB UNK64X3184Accident · Serious injuriesClosedCessna 120 · Danville, INNTSB UNK64X3085Accident · No injuriesClosedLuscombe 11A · Indianapolis, INNTSB UNK64X3030Accident · No injuriesClosedCessna 172 · Rushville, IN