NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 NYC66D0420Accident · No injuriesClosedCessna 310C · Philadelphia, PANTSB NYC66F0405Accident · No injuriesClosedPiper P A-28 · Mt Alton, PANTSB NYC66F0401Accident · Minor injuriesClosedPiper PA-22 · Butler, PANTSB NYC66D0434Accident · No injuriesClosedCessna 195 · Philadelphia, PANTSB NYC66D0453Accident · Minor injuriesClosedErcoupe 415-C · Londonderry Tp, PANTSB NYC66D0424Accident · Minor injuriesClosedCessna 172 · Pittsburg, PANTSB NYC66A0066Accident · 1 fatalClosedPiper PA-28 · Reading, PANTSB NYC66A0064Accident · 2 fatalClosedMaule M-4 · Windber, PANTSB NYC66F0410Accident · No injuriesClosedAero Cmdr 680-E · Philadelphia, PANTSB NYC66D0364Accident · No injuriesClosedBeechcraft A-23 · Doylestown, PANTSB NYC66D0362Accident · No injuriesClosedPiper PA-28 · Langhorne, PANTSB NYC66F0363Accident · No injuriesClosedNavion A · Morrisville, PANTSB NYC66D0383Accident · No injuriesClosedCessna 210E · New Cumberland, PANTSB NYC66F0392Accident · Serious injuriesClosedCessna 190 · Latrobe, PANTSB NYC66D0355Accident · No injuriesClosedStinson 108-1 · Mechanicsburg, PANTSB NYC66F0353Accident · No injuriesClosedCessna 182 · Kutztown, PANTSB NYC66D0352Accident · No injuriesClosedPiper PA-28 · Mt Pocono, PANTSB NYC66A0053Accident · Serious injuriesClosedDouglas DC-3 · Coraopolis, PANTSB NYC66D0346Accident · No injuriesClosedMooney M20C · Kane, PANTSB NYC66F0326Accident · No injuriesClosedStearman Hamond · Honesdale, PANTSB NYC66D0335Accident · No injuriesClosedCessna 175 · Lewiston, PANTSB NYC66F0393Accident · No injuriesClosedPiper PA-24 · West Mifflin, PANTSB NYC66F0376Accident · No injuriesClosedBellanca 14-13 · Somerset, PANTSB NYC66F0347Accident · No injuriesClosedPiper PA24 · Lock Haven, PANTSB NYC66D0345Accident · No injuriesClosedPiper PA-22 · Butler, PANTSB NYC66F0289Accident · No injuriesClosedCessna 150 · West Chester, PANTSB NYC66A0048Accident · No injuriesClosedBensen B8M · Benton, PANTSB NYC66F0253Accident · No injuriesClosedBeechcraft C-35 · Newton, PANTSB NYC66F0254Accident · Serious injuriesClosedPiper PA-28 · Philadelphia, PANTSB NYC66D0296Accident · No injuriesClosedCessna 175 · Bedford, PANTSB NYC66F0319Accident · No injuriesClosedHelio MK2 · Shippenville, PANTSB NYC66D0360Accident · No injuriesClosedCessna 172 · Erie, PANTSB NYC66F0238Accident · No injuriesClosedPiper PA-23 · Allentown, PANTSB NYC66D0255Accident · No injuriesClosedMooney M20A · Avondale, PANTSB NYC66D0336Accident · Minor injuriesClosedPiper J3C-65 · Brockport, PANTSB NYC66F0227Accident · No injuriesClosedStinson 108-2 · Franklin, PANTSB NYC66F0199Accident · No injuriesClosedPiper PA-28 · Morrisville, PANTSB NYC66A0032Accident · 1 fatalClosedStinson 108-3 · Milroy, PANTSB NYC66D0197Accident · No injuriesClosedAeronca 7AC · West Chester, PANTSB NYC66F0221Accident · No injuriesClosedPiper J3C · Monroeville, PANTSB NYC66F0208Accident · No injuriesClosedCessna 180 · Tarentum, PANTSB NYC66A0030Accident · 1 fatalClosedNavion A · St Marys, PANTSB NYC66A0029Accident · 4 fatalClosedMaule BD-M-4 · Champion, PANTSB NYC66D0229Accident · No injuriesClosedNavion B · Elysburg, PANTSB NYC66D0198Accident · No injuriesClosedPiper PA-22 · State College, PANTSB NYC66F0233Accident · Serious injuriesClosedPiper PA15 · Bloomsburg, PANTSB NYC66F0214Accident · Minor injuriesClosedNavion 4 · Austin, PANTSB NYC66F0205Accident · No injuriesClosedCessna 182A · Dravosburg, PANTSB NYC66A0027Accident · Minor injuriesClosedBrantly 305 · Millheim, PANTSB NYC66F0230Accident · No injuriesClosedCessna 140 · Keating, PA