NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 CHI66F0501Accident · No injuriesClosedPiper PA-24 · Wabash, INNTSB CHI66F0475Accident · No injuriesClosedPiper PA-23 · Muncie, INNTSB CHI66F0500Accident · No injuriesClosedMooney M-20E · Indianapolis, INNTSB CHI66F0492Accident · No injuriesClosedBeechcraft N35 · Mishawaka, INNTSB CHI66A0060Accident · 3 fatalClosedPiper PA-23 · Knox, INNTSB CHI66D0504Accident · No injuriesClosedPiper PA-24 · Indianapolis, INNTSB CHI66A0058Accident · 1 fatalClosedCessna 150F · South Bend, INNTSB CHI66D0473Accident · No injuriesClosedMooney M20B · Indianapolis, INNTSB CHI66A0054Accident · No injuriesClosedBell 47G-4 · Indianapolis, INNTSB CHI66D0487Accident · No injuriesClosedCessna 175 · Syracuse, INNTSB CHI66D0484Accident · No injuriesClosedPiper PA-28 · Auburn, INNTSB CHI66F0433Accident · No injuriesClosedCessna 182 · South Bend, INNTSB CHI66F0413Accident · Minor injuriesClosedPiper J3C-65 · Greenfield, INNTSB CHI66F0405Accident · No injuriesClosedLuscombe 8A · Kempton, INNTSB CHI66F0399Accident · Minor injuriesClosedPiper PA-16 · Ladoga, INNTSB CHI66F0378Accident · No injuriesClosedPiper PA-30 · Muncie, INNTSB CHI66F0430Accident · No injuriesClosedCessna 172 · Fort Wayne, INNTSB CHI66F0418Accident · No injuriesClosedBeechcraft D18S · Valparaiso, INNTSB CHI66F0407Accident · 1 fatalClosedSchweizer SGS126 · Ramsey, INNTSB CHI66D0439Accident · No injuriesClosedPiper PA-28 · Franklin, INNTSB CHI66D0456Accident · No injuriesClosedBeechcraft D-18S · Ft Wayne, INNTSB CHI66A0044Accident · 1 fatalClosedCessna 172 · Liberty, INNTSB CHI66D0432Accident · No injuriesClosedPiper PA-20 · Ft Wayne, INNTSB CHI66F0619Accident · No injuriesClosedBeechcraft 23 · Fort Wayne, INNTSB CHI66F0400Accident · Serious injuriesClosedPiper PA-28 · Portage, INNTSB CHI66D0379Accident · No injuriesClosedCessna 172 · Greenwood, INNTSB CHI66A0037Accident · 2 fatalClosedNavion A · Spencer, INNTSB CHI66F0434Accident · No injuriesClosedAero Cmdr 560-A · Valparaiso, INNTSB CHI66A0032Accident · 1 fatalClosedAir Space 18A · Muncie, INNTSB CHI66F0381Accident · No injuriesClosedPiper PA-12 · Rensselaer, INNTSB CHI66D0319Accident · No injuriesClosedCessna 150 · Crawfordsville, INNTSB CHI66D0438Accident · Minor injuriesClosedTaylorcraft BC12-D · Cedar Grove, INNTSB CHI66F0351Accident · No injuriesClosedCessna 172 · Roselawn, INNTSB CHI66F0318Accident · No injuriesClosedPiper PA-30 · Madison, INNTSB CHI66A0027Accident · Serious injuriesClosedAir Space 18A · Hobart, INNTSB CHI66D0312Accident · No injuriesClosedCessna 172 · Nft Wayne, INNTSB CHI66F0308Accident · No injuriesClosedBeechcraft C-18S · Jamestown, INNTSB CHI66D0198Accident · No injuriesClosedAero Cmdr 680F · Indianapolis, INNTSB CHI66F0313Accident · No injuriesClosedPiper PA-22 · Clermont, INNTSB CHI66F0338Accident · Minor injuriesClosedBeechcraft D-17S · Evansville, INNTSB CHI66F0385Accident · No injuriesClosedPiper PA-28 · Kendallville, INNTSB CHI66F0221Accident · Serious injuriesClosedBeech H35 · Dunkirk, INNTSB CHI66D0228Accident · No injuriesClosedPiper PA-28 · Chesterton, INNTSB CHI66A0020Accident · No injuriesClosedBrantly B2 · Williamsport, INNTSB CHI66F0185Accident · No injuriesClosedPiper PA-28 · Culver, INNTSB CHI66D0192Accident · No injuriesClosedCessna 172 · Milan, INNTSB CHI66F0202Accident · No injuriesClosedCessna 140 · Mooresville, INNTSB CHI66D0176Accident · No injuriesClosedCessna 170B · Valpariso, INNTSB CHI66F0154Accident · No injuriesClosedPiper PA-22 · Indianapolis, INNTSB CHI66F0124Accident · No injuriesClosedMooney M20D · Woodburn, IN