NTSB investigations, 1966, 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\") = 1966
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") = 1966 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 CHI67F0433Accident · No injuriesClosedBellanca 14-13 · Warsaw, INNTSB CHI67D0417Accident · No injuriesClosedCessna 172 · Bloomingdale, INNTSB CHI67F0520Accident · Minor injuriesClosedCessna 140 · Rosedale, INNTSB CHI67F0438Accident · Serious injuriesClosedAero Comdr 680F · Elkhart, INNTSB CHI67F0405Accident · No injuriesClosedCessna 175A · Martinsville, INNTSB CHI67D0373Accident · No injuriesClosedCessna 182 · Indianapolis, INNTSB CHI67F0406Accident · No injuriesClosedPiper PA-23 · Middlebury, INNTSB CHI67F0378Accident · No injuriesClosedCessna 150 · Angola, INNTSB CHI67D0364Accident · No injuriesClosedPiper PA-32 · Richmond, INNTSB CHI67A0069Accident · 1 fatalClosedBeech A23 · Forest, INNTSB CHI67F0383Accident · No injuriesClosedN.American 265-40 · Evansville, INNTSB CHI67F0294Accident · No injuriesClosedCessna 150 · Lewis, INNTSB CHI67F0391Accident · No injuriesClosedCessna 310D · Griffith, INNTSB CHI67I0059Incident · No injuriesClosedDouglas DC-6B · Ft.Wayne, INNTSB CHI67D0357Accident · No injuriesClosedPiper PA-28 · Logansport, INNTSB CHI67A0054Accident · Serious injuriesClosedBensen B7MC · French Lick, INNTSB CHI67A0051Accident · 3 fatalClosedPiper PA-24 · Danville, INNTSB CHI67A0047Accident · Minor injuriesClosedBell 47G · Milford, INNTSB CHI67F0277Accident · No injuriesClosedCessna 182E · Anderson, INNTSB CHI67A0045Accident · 3 fatalClosedPiper PA-22 · Knox, INNTSB CHI67D0278Accident · No injuriesClosedMooney M20E · Richmond, INNTSB CHI67A0046Accident · Serious injuriesClosedLockheed L-188 · Indianapolis, INNTSB CHI67F0221Accident · No injuriesClosedCessna 210 · Indianapolis, INNTSB CHI67F0291Accident · No injuriesClosedPiper PA-24 · Indianapolis, INNTSB CHI67D0257Accident · No injuriesClosedSailplane BG-12 · Rising Sun, INNTSB CHI67F0152Accident · No injuriesClosedBeech D18S · Kokomo, INNTSB CHI67A0032Accident · 3 fatalClosedPiper PA-24 · Fort Wayne, INNTSB CHI67F0187Accident · No injuriesClosedWaco INF · Mishawaka, INNTSB CHI67F0235Accident · No injuriesClosedBeech C35 · Elkhart, INNTSB CHI67A0027Accident · 3 fatalClosedNavion NAV-4 · Terre Haute, INNTSB CHI67D0139Accident · No injuriesClosedErcoupe 415-D · Cloverdale, INNTSB CHI67D0158Accident · No injuriesClosedPiper PA-22 · Mooresville, INNTSB CHI67F0116Accident · No injuriesClosedCessna 320 · Michigan City, INNTSB CHI67F0167Accident · No injuriesClosedGlobe GC-1B · Lafayette, INNTSB CHI67F0240Accident · Serious injuriesClosedAero Comdr 520 · Gary, INNTSB CHI67F0236Accident · No injuriesClosedPiper PA-28 · Hobart, INNTSB CHI67F0143Accident · No injuriesClosedWaco YKC-S · Muncie, INNTSB CHI67F0126Accident · Serious injuriesClosedNavion A · Whiteland, INNTSB CHI67D0137Accident · No injuriesClosedCessna 172 · Muncie, INNTSB CHI67F0183Accident · No injuriesClosedN.American P-51D · Fort Wayne, INNTSB CHI67F0243Accident · Serious injuriesClosedGrumman G-44 · Kendallville, INNTSB CHI67F0133Accident · Serious injuriesClosedScheibe L-55 · Whitestown, INNTSB CHI67D0153Accident · No injuriesClosedCessna 150 · Bloomington, INNTSB CHI67F0140Accident · No injuriesClosedPiper PA-24 · Culver, INNTSB CHI67F0200Accident · No injuriesClosedPiper PA-16 · South Bend, INNTSB CHI67F0170Accident · No injuriesClosedPiper PA-24 · Untington, INNTSB CHI67A0012Accident · 4 fatalClosedBeech H50 · Munster, INNTSB CHI67F0108Accident · No injuriesClosedPiper PA-28 · Columbia City, INNTSB CHI66A0011Accident · 1 fatalClosedBoeing IB75A · Valparaiso, INNTSB CHI67D0132Accident · No injuriesClosedPiper PA-32 · Richmond, IN