NTSB investigations, 1973, IN
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1973
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") = 1973 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 CHI74FET16Accident · Serious injuriesClosedPiper PA-24 · Fort Wayne, INNTSB CHI74AC051Accident · 2 fatalClosedBeech 95-C55 · Rochester, INNTSB CHI74DET15Accident · No injuriesClosedBeech A35 · Logansport, INNTSB CHI74DEA22Accident · No injuriesClosedPiper PA-22 · Francisco, INNTSB CHI74DEA21Accident · No injuriesClosedPiper PA-28R · Madison, INNTSB CHI74AC042Accident · 5 fatalClosedCessna 421 · Plymouth, INNTSB CHI74FEA20Accident · No injuriesClosedPiper PA-22 · Monroe City, INNTSB CHI74DEA19Accident · No injuriesClosedCessna 172 · Terre Haute, INNTSB CHI74FET11Accident · Serious injuriesClosedCessna 150 · Michigan City, INNTSB CHI74DEA18Accident · Minor injuriesClosedCessna 150 · Brazil, INNTSB CHI74FET12Accident · No injuriesClosedPiper PA-34 · Osceola, INNTSB CHI74FEA17Accident · Minor injuriesClosedPiper PA-23 · Terre Haute, INNTSB CHI74FEA16Accident · Minor injuriesClosedCessna 172F · Lafayette, INNTSB CHI74FEA15Accident · 1 fatalClosedCorbin B-ACE · Franklin, INNTSB CHI74AC027Accident · Minor injuriesClosedLockheed 1049H · Gary, INNTSB CHI74FEA14Accident · Serious injuriesClosedTeenie TWO · Monticello, INNTSB CHI74DET10Accident · Minor injuriesClosedCessna 172 · Peru, INNTSB CHI74DEA13Accident · No injuriesClosedBell 47G-2A · Veedersburg, INNTSB CHI74FET09Accident · No injuriesClosedCessna 182F · Elkhart, INNTSB CHI74FET08Accident · Serious injuriesClosedCessna 182P · Valparaiso, INNTSB CHI74AC020Accident · 2 fatalClosedCessna 337A · Gary, INNTSB CHI74DET07Accident · Minor injuriesClosedLuscombe 8F · Crown Point, INNTSB CHI74FEA09Accident · No injuriesClosedPiper PA-24 · Lanesville, INNTSB CHI74DEA12Accident · No injuriesClosedPiper PA-28 · Radnor, INNTSB CHI74AC016Accident · Serious injuriesClosedAero Comdr 520 · Michigan City, INNTSB CHI74AC015Accident · 1 fatalClosedStinson L-5E · Demotte, INNTSB CHI74FET06Accident · No injuriesClosedCessna 310C · Griffith, INNTSB CHI74FET04Accident · No injuriesClosedPiper PA-23 · Walton, INNTSB CHI74DEA08Accident · No injuriesClosedPiper PA-25 · Kentland, INNTSB CHI74DET05Accident · No injuriesClosedPiper PA-25 · Morocco, INNTSB CHI74AC010Accident · 1 fatalClosedPiper PA-28R · Fountaintown, INNTSB CHI74DET02Accident · Serious injuriesClosedJeanies TWO · Merriville, INNTSB CHI74FEA06Accident · No injuriesClosedPiper PA-22 · Hartford City, INNTSB CHI74DEA10Accident · No injuriesClosedPiper PA-28 · Kokomo, INNTSB CHI74DEA07Accident · No injuriesClosedGreat Lakes Baby · Anderson, INNTSB CHI74FEA04Accident · Serious injuriesClosedBell 47G-3 · Dana, INNTSB CHI74FEA11Accident · No injuriesClosedCessna 210D · Evansville, INNTSB CHI74FEA03Accident · No injuriesClosedBell 47G-2A · Little York, INNTSB CHI74DEA05Accident · No injuriesClosedPitts S1-D · Greentown, INNTSB CHI74FEA02Accident · No injuriesClosedAeronca 7AC · Speedway, INNTSB CHI74AC003Accident · 4 fatalClosedCessna 172F · No.Webster, INNTSB CHI74AC001Accident · 4 fatalClosedCessna T210J · Pleasant Lake, INNTSB CHI74FEA01Accident · Minor injuriesClosedCessna 210 · North Vernon, INNTSB CHI73FET25Accident · Minor injuriesClosedChampion 7KCAB · Griffith, INNTSB CHI73DEA42Accident · No injuriesClosedPiper PA-20 · Portland, INNTSB CHI73DEA40Accident · No injuriesClosedCessna 150F · Mc Cordsville, INNTSB CHI73DEA39Accident · No injuriesClosedCessna 172 · Hagerstown, INNTSB CHI73DEA41Accident · No injuriesClosedCessna 182 · Ramsey, INNTSB CHI73FEA38Accident · Serious injuriesClosedBeech 23 · Lanesville, INNTSB CHI73AC095Accident · 1 fatalClosedRyan ST-3KR · Greenfield, IN