NTSB investigations, 1966, OH
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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\") = 1966
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") = 1966 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 CHI67D0451Accident · No injuriesClosedCessna 172 · Chagrin Fall, OHNTSB CHI67D0445Accident · No injuriesClosedPiper PA-22 · Toledo, OHNTSB CHI67D0384Accident · Minor injuriesClosedBeech A35 · Concord, OHNTSB CHI67A0083Accident · No injuriesClosedScheutzow B · Brunswick, OHNTSB CHI67D0421Accident · No injuriesClosedBeech B95 · Napoleon, OHNTSB CHI67I0078Incident · Serious injuriesClosedBoeing 720 · Cleveland, OHNTSB CHI67A0081Accident · 4 fatalClosedCessna 172 · Ashtabula, OHNTSB CHI67D0427Accident · No injuriesClosedCessna 140 · Cleveland, OHNTSB CHI67D0415Accident · No injuriesClosedPiper PA-22 · Huron, OHNTSB CHI67F0397Accident · Serious injuriesClosedCessna 210E · Minford, OHNTSB CHI67A0073Accident · 1 fatalClosedBeech A23-19 · Toledo, OHNTSB CHI67A0072Accident · 1 fatalClosedPiper PA-22 · Pataskala, OHNTSB CHI67F0398Accident · No injuriesClosedPiper PA-22 · Elyria, OHNTSB CHI67F0381Accident · Minor injuriesClosedPiper PA-23 · Springboro, OHNTSB CHI67D0399Accident · Minor injuriesClosedPiper PA-22 · Sycamore, OHNTSB CHI67D0380Accident · No injuriesClosedPiper PA-22 · Toledo, OHNTSB CHI67D0446Accident · No injuriesClosedAero Cmdr 680 · Lorain, OHNTSB CHI67D0407Accident · No injuriesClosedPiper PA-12 · Bowling Grn, OHNTSB CHI67F0336Accident · No injuriesClosedPiper PA-28 · Blue Ash, OHNTSB CHI67F0330Accident · Minor injuriesClosedPiper PA-28 · Hebron, OHNTSB CHI67D0379Accident · No injuriesClosedMooney M20C · Bowling Grn, OHNTSB CHI67F0318Accident · No injuriesClosedBeech A45 · W.Carrollton, OHNTSB CHI67F0304Accident · No injuriesClosedStinson 108-1 · Columbus, OHNTSB CHI67D0367Accident · Minor injuriesClosedCessna 150 · Kent, OHNTSB CHI67A0056Accident · Serious injuriesClosedBell 47G · Wickliffe, OHNTSB CHI67F0281Accident · Serious injuriesClosedCessna U206 · Columbus, OHNTSB CHI67D0366Accident · No injuriesClosedBeechcraft A23 · Medina, OHNTSB CHI67A0053Accident · 2 fatalClosedPiper PA-22 · Stow, OHNTSB CHI67F0299Accident · No injuriesClosedPiper PA-28 · Cleveland, OHNTSB CHI67D0369Accident · No injuriesClosedPiper PA-24 · N, OHNTSB CHI67F0329Accident · No injuriesClosedCessna 150 · Strongsville, OHNTSB CHI67F0242Accident · No injuriesClosedErco 415-C · Dayton, OHNTSB CHI67D0276Accident · No injuriesClosedCessna 150 · Grove City, OHNTSB CHI67D0255Accident · No injuriesClosedPiper PA-28 · Vandalia, OHNTSB CHI67D0345Accident · No injuriesClosedPiper PA-28 · Stow, OHNTSB CHI67F0204Accident · Minor injuriesClosedPiper PA-28 · Columbus, OHNTSB CHI67D0274Accident · No injuriesClosedMooney M21 · Cleveland, OHNTSB CHI67F0275Accident · No injuriesClosedCessna 120 · Oxford, OHNTSB CHI67F0224Accident · Minor injuriesClosedAeronca 7AC · Middletown, OHNTSB CHI67A0014Accident · 1 fatalClosedPiper PA-28 · Whitehall, OHNTSB CHI67F0300Accident · Minor injuriesClosedPiper PA-28 · Medina, OHNTSB CHI67D0338Accident · No injuriesClosedPiper PA-28 · Medina, OHNTSB CHI67F0214Accident · No injuriesClosedPiper PA-23 · Cincinnatti, OHNTSB CHI67F0283Accident · Minor injuriesClosedTaylorcraft BC12-D · Elyria, OHNTSB CHI67D0395Accident · No injuriesClosedCessna 180 · Grafton, OHNTSB CHI67D0245Accident · No injuriesClosedCessna 172C · Xenia, OHNTSB CHI67D0188Accident · No injuriesClosedAeronca 7GCB · Duncan Falls, OHNTSB CHI67D0186Accident · No injuriesClosedCessna 172 · Greenville, OHNTSB CHI67A0038Accident · 4 fatalClosedCessna 172 · South Russel, OHNTSB CHI67D0273Accident · No injuriesClosedCessna 150 · Middle Bass, OH