NTSB investigations, 1976, OH
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
| 1962 | 1 |
|---|---|
| 1963 | 1 |
| 1964 | 199 |
| 1965 | 184 |
| 1966 | 193 |
| 1967 | 189 |
| 1968 | 187 |
| 1969 | 129 |
| 1970 | 142 |
| 1971 | 147 |
| 1972 | 121 |
| 1973 | 124 |
| 1974 | 142 |
| 1975 | 101 |
| 1976 | 103 |
| 1977 | 112 |
| 1978 | 99 |
| 1979 | 115 |
| 1980 | 109 |
| 1981 | 81 |
| 1982 | 81 |
| 1983 | 81 |
| 1984 | 84 |
| 1985 | 73 |
| 1986 | 59 |
| 1987 | 69 |
| 1988 | 59 |
| 1989 | 74 |
| 1990 | 52 |
| 1991 | 52 |
| 1992 | 56 |
| 1993 | 46 |
| 1994 | 52 |
| 1995 | 54 |
| 1996 | 44 |
| 1997 | 43 |
| 1998 | 29 |
| 1999 | 38 |
| 2000 | 46 |
| 2001 | 33 |
| 2002 | 39 |
| 2003 | 46 |
| 2004 | 34 |
| 2005 | 37 |
| 2006 | 23 |
| 2007 | 41 |
| 2008 | 43 |
| 2009 | 32 |
| 2010 | 37 |
| 2011 | 43 |
| 2012 | 30 |
| 2013 | 22 |
| 2014 | 29 |
| 2015 | 17 |
| 2016 | 34 |
| 2017 | 33 |
| 2018 | 33 |
| 2019 | 27 |
| 2020 | 22 |
| 2021 | 27 |
| 2022 | 30 |
| 2023 | 19 |
| 2024 | 16 |
| 2025 | 23 |
| 2026 | 23 |
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\") = 1976
AND c.\"eventStateOrRegion\" = 'OH' 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") = 1976 AND c."eventStateOrRegion" = 'OH' 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 CHI77FEI08Accident · Minor injuriesClosedPiper PA-28 · Avon Lake, OHNTSB CHI77FA017Accident · 1 fatalClosedPiper PA-23 · North Royalton, OHNTSB CHI77FEI07Accident · No injuriesClosedPiper PA-30 · North Benton, OHNTSB CHI77FEI06Accident · Serious injuriesClosedPiper PA-22 · Painesville, OHNTSB CHI77FA012Accident · 1 fatalClosedCessna 177 · Harrison, OHNTSB CHI77FEK08Accident · Serious injuriesClosedPiper PA-23 · Mt Sterling, OHNTSB CHI77FEI05Accident · No injuriesClosedCessna 150 · Vienna, OHNTSB CHI77FA009Accident · Serious injuriesClosedSikorsky S-58B · Hartford Twp, OHNTSB NYC77FA013Accident · Serious injuriesClosedDouglas DC-9 · Appleton, OHNTSB CHI77FEK07Accident · No injuriesClosedCessna 421B · Findlay, OHNTSB CHI77FEK05Accident · Minor injuriesClosedEnstrom F-28A · Columbus, OHNTSB CHI77DEG05Accident · No injuriesClosedCessna 180 · Lebanon, OHNTSB CHI77FEK06Accident · No injuriesClosedPiper PA-28 · Columbus, OHNTSB CHI77FEG04Accident · No injuriesClosedPiper PA-28 · Blue Ash, OHNTSB CHI77FEI04Accident · Minor injuriesClosedGrum Amer AA-5B · Millbury, OHNTSB CHI77FEK04Accident · Serious injuriesClosedGrum Amer AA1-B · Columbus, OHNTSB CHI77FEI03Accident · No injuriesClosedPiper PA-24 · Akron, OHNTSB CHI77DEG02Accident · No injuriesClosedBellanca 7ECA · Moraine, OHNTSB CHI77DEG03Accident · Minor injuriesClosedBellanca 7ECA · Moraine, OHNTSB CHI77FEK03Accident · Minor injuriesClosedPiper PA-28 · Celina, OHNTSB CHI77FEI02Accident · No injuriesClosedCessna 172L · Stronsville, OHNTSB CHI77FEK02Accident · 2 fatalClosedBel-Spezio BEL · Rockbridge, OHNTSB CHI77FEG01Accident · No injuriesClosedCessna 172 · Hamilton, OHNTSB CHI77FEI01Accident · No injuriesClosedPiper PA-30 · Mansfield, OHNTSB CHI77FEK01Accident · No injuriesClosedBell 47D1 · Johnstown, OHNTSB CHI76FEI50Accident · Minor injuriesClosedUniversal GC-1B · Richmond Hts, OHNTSB CHI76FEK32Accident · No injuriesClosedCessna 150 · Columbus, OHNTSB CHI76FEK31Accident · No injuriesClosedMooney M20E · Urbana, OHNTSB CHI76FEK29Accident · No injuriesClosedPiper PA-34 · Columbus, OHNTSB CHI76FEK30Accident · No injuriesClosedTransworld 47G-2 · Leipsic, OHNTSB CHI76AC092Accident · 1 fatalClosedCessna 210B · Hamilton, OHNTSB CHI76FEI49Accident · Minor injuriesClosedCessna 150L · Millbury, OHNTSB CHI76DEG23Accident · No injuriesClosedPiper PA-28 · Wilmington, OHNTSB CHI76FEI48Accident · No injuriesClosedBeech B19 · Strongsville, OHNTSB CHI76FEK28Accident · Minor injuriesClosedCessna 182 · Johnston, OHNTSB CHI76FEI47Accident · Minor injuriesClosedPiper PA-32 · Baltic, OHNTSB CHI76FEK27Accident · No injuriesClosedCessna 172G · London, OHNTSB CHI76FEI46Accident · No injuriesClosedPiper PA-28 · Salem, OHNTSB CHI76FEI44Accident · No injuriesClosedCessna 182 · Chagrin Falls, OHNTSB CHI76FEI43Accident · No injuriesClosedEL Tomcat Mark V · Mantua, OHNTSB CHI76DEG22Accident · No injuriesClosedRuby RR-1 · Martinsville, OHNTSB CHI76FEI45Accident · No injuriesClosedPiper PA-24 · Bowling Green, OHNTSB CHI76FEK26Accident · Minor injuriesClosedPiper PA-32 · Walhonding, OHNTSB CHI76FEG21Accident · No injuriesClosedCessna 177 · Kettering, OHNTSB CHI76AC084Accident · 2 fatalClosedEnstrom F-28A · Enon, OHNTSB CHI76FEI41Accident · 1 fatalClosedRockwell 112A · Perrysville, OHNTSB CHI76FEK25Accident · No injuriesClosedCessna 310 · Columbus, OHNTSB CHI76FEG20Accident · Minor injuriesClosedTaylorcraft BC-12D · Dayton, OHNTSB CHI76FEI42Accident · Minor injuriesClosedPiper PA-28 · Avon, OHNTSB CHI76FEK23Accident · No injuriesClosedPiper PA-22 · Baltimore, OH