NTSB investigations, 1964, PA
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 | 2 |
|---|---|
| 1964 | 157 |
| 1965 | 149 |
| 1966 | 172 |
| 1967 | 192 |
| 1968 | 154 |
| 1969 | 132 |
| 1970 | 136 |
| 1971 | 153 |
| 1972 | 104 |
| 1973 | 118 |
| 1974 | 143 |
| 1975 | 131 |
| 1976 | 123 |
| 1977 | 116 |
| 1978 | 124 |
| 1979 | 109 |
| 1980 | 89 |
| 1981 | 92 |
| 1982 | 96 |
| 1983 | 81 |
| 1984 | 84 |
| 1985 | 75 |
| 1986 | 64 |
| 1987 | 64 |
| 1988 | 65 |
| 1989 | 45 |
| 1990 | 65 |
| 1991 | 47 |
| 1992 | 47 |
| 1993 | 48 |
| 1994 | 41 |
| 1995 | 55 |
| 1996 | 38 |
| 1997 | 56 |
| 1998 | 40 |
| 1999 | 41 |
| 2000 | 47 |
| 2001 | 34 |
| 2002 | 35 |
| 2003 | 29 |
| 2004 | 37 |
| 2005 | 33 |
| 2006 | 36 |
| 2007 | 35 |
| 2008 | 33 |
| 2009 | 30 |
| 2010 | 19 |
| 2011 | 27 |
| 2012 | 39 |
| 2013 | 27 |
| 2014 | 24 |
| 2015 | 35 |
| 2016 | 32 |
| 2017 | 33 |
| 2018 | 28 |
| 2019 | 30 |
| 2020 | 19 |
| 2021 | 28 |
| 2022 | 35 |
| 2023 | 11 |
| 2024 | 19 |
| 2025 | 17 |
| 2026 | 12 |
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\") = 1964
AND c.\"eventStateOrRegion\" = 'PA' 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") = 1964 AND c."eventStateOrRegion" = 'PA' 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 UNK65X1204Accident · No injuriesClosedCessna 182 · Benton, PANTSB UNK65X1100Accident · No injuriesClosedBeechcraft B55 · Allentown, PANTSB UNK65X1099Accident · No injuriesClosedBell 47J2 · Philadelphia, PANTSB UNK65X1045Accident · Minor injuriesClosedBrantly B2B · Hawthorn, PANTSB UNK65X1028Accident · No injuriesClosedCessna 310C · Bedford, PANTSB UNK65X1022Accident · No injuriesClosedVickers VI745D · Franklin, PANTSB UNK65X0968Accident · No injuriesClosedPiper PA24 · Philadelphia, PANTSB UNK65X0895Accident · No injuriesClosedChampion 7FC · Berwick, PANTSB UNK65X0890Accident · Serious injuriesClosedPiper PA22 · St Marys, PANTSB UNK65X0870Accident · 4 fatalClosedCessna 172 · Philadelphia, PANTSB UNK65X0858Accident · Minor injuriesClosedAeronca 7AC · Emporium, PANTSB UNK65X0846Accident · Minor injuriesClosedPiper PA22 · Warren, PANTSB UNK65X0844Accident · 3 fatalClosedCessna 310B · Clarks Summit, PANTSB UNK65X0829Accident · Serious injuriesClosedPiper PA-24 · Mars, PANTSB UNK65X0821Accident · Minor injuriesClosedPiper PA-22 · Waynesburg, PANTSB UNK65X0717Accident · No injuriesClosedCessna 140A · Somerset, PANTSB UNK65X0703Accident · No injuriesClosedCessna 210D · West Mifflin, PANTSB UNK65X0702Accident · No injuriesClosedStinson 108-1 · Collegeville, PANTSB UNK65X0701Accident · Minor injuriesClosedTaylorcraft DC065 · Emlenton, PANTSB UNK65X0599Accident · No injuriesClosedMooney M21 · Clarks Summit, PANTSB UNK65X0587Accident · 1 fatalClosedPiper PA-28 · Center Valley, PANTSB UNK65X0563Incident · No injuriesClosedViscount 745 · Harrisburg, PANTSB UNK65X0539Accident · No injuriesClosedBeechcraft B50 · Waynesburg, PANTSB UNK65X0495Accident · No injuriesClosedCurtis C-46F · Pittsburgh, PANTSB UNK65X0494Accident · Serious injuriesClosedPiper PA24 · Stahlstown, PANTSB UNK65X0461Accident · No injuriesClosedCessna 310C · Phillipsburg, PANTSB UNK65X0435Accident · No injuriesClosedCessna 150 · Clarion, PANTSB UNK65X0426Accident · No injuriesClosedTaylorcraft BC1265 · Slate Run, PANTSB UNK65X0408Accident · No injuriesClosedCesna 310 · Kylertown, PANTSB UNK65X0354Incident · No injuriesClosedBoeing 727-23 · Allentown, PANTSB UNK65X0353Accident · No injuriesClosedCessna T-50 · Collegeville, PANTSB UNK65X0327Accident · No injuriesClosedBeechcraft 23 · Clark Summits, PANTSB UNK65X0324Accident · No injuriesClosedAeronca 7DC · Bridgeville, PANTSB UNK65X0294Accident · No injuriesClosedBeechcraft K35 · State College, PANTSB UNK65X0196Accident · No injuriesClosedCessna 140 · Slate Run, PANTSB UNK65X0172Accident · No injuriesClosedAeronca 65C · Dalton, PANTSB UNK65X0163Accident · No injuriesClosedCessna 182F · Lancaster, PANTSB UNK65X0154Accident · No injuriesClosedCessna 150 · Allentown, PANTSB UNK65X0119Accident · No injuriesClosedPiper PA30 · Reading, PANTSB UNK64X4220Accident · No injuriesClosedLuscombe 8E · Butler, PANTSB UNK64X4178Accident · No injuriesClosedCessna 172 · Lancaster, PANTSB UNK64X4135Incident · No injuriesClosedBoeing 707 131B · Reading, PANTSB UNK64X4057Accident · 3 fatalClosedCessna 170B · Ickesburg, PANTSB UNK64X4034Accident · No injuriesClosedPiper PA24 · Phildelphia, PANTSB UNK64X4015Accident · No injuriesClosedPiper PA22 · Blawnox, PANTSB UNK64X3999Accident · No injuriesClosedPiper PA24 · Ulysses, PANTSB UNK64X3990Accident · No injuriesClosedPiper PA28 · Lewistown, PANTSB UNK64X3969Accident · No injuriesClosedNavion · Honesdale, PANTSB UNK64X3952Accident · 1 fatalClosedCessna 175 · Quakertown, PANTSB UNK64X3915Accident · Minor injuriesClosedPiper PA28 · Martinsburg, PA