NTSB investigations, 1966, PA
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 | 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\") = 1966
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") = 1966 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 NYC67D0439Accident · No injuriesClosedPiper PA-22 · Clarion, PANTSB NYC67F0574Accident · No injuriesClosedPiper PA-24 · Coraopolis, PANTSB NYC67F0428Accident · No injuriesClosedPiper PA-24 · Selinsgrove, PANTSB NYC67D0675Accident · No injuriesClosedCessna 172C · Greenville, PANTSB NYC67F0438Accident · No injuriesClosedLuscombe 8E · Aliquippa, PANTSB NYC67F0411Accident · No injuriesClosedCessna 411 · Erie, PANTSB NYC67D0480Accident · Minor injuriesClosedPiper PA-28 · Millcreek, PANTSB NYC67D0417Accident · No injuriesClosedAeronca 7AC · Mechanicsburg, PANTSB NYC67A0091Accident · No injuriesClosedPiper PA-23 · Lock Haven, PANTSB NYC67D0397Accident · No injuriesClosedNavion G · West Chester, PANTSB NYC67A0089Accident · No injuriesClosedConvair 340 · New Cumberland, PANTSB NYC67A0085Accident · 1 fatalClosedPiper PA-18 · Northeast, PANTSB NYC67A0083Accident · 4 fatalClosedPiper PA-23 · Lewisburg, PANTSB NYC67A0082Accident · No injuriesClosedPiper PA-24 · Berwick, PANTSB NYC67F0378Accident · No injuriesClosedMaule M4 · Mt Pleasant, PANTSB NYC67F0349Accident · No injuriesClosedCessna 320B · Easton, PANTSB NYC67F0367Accident · No injuriesClosedCessna 180 · Culmerville, PANTSB NYC67F0372Accident · Serious injuriesClosedStinson 108-3 · New Castle, PANTSB NYC67D0379Accident · No injuriesClosedPiper PA-28 · Clearfield, PANTSB NYC67D0374Accident · No injuriesClosedMooney M20E · Johnstown, PANTSB NYC67F0377Accident · No injuriesClosedCessna 150 · Hiladelphia, PANTSB NYC67D0358Accident · No injuriesClosedPiper PA-24 · Pottstown, PANTSB NYC67A0077Accident · 3 fatalClosedBeech S35 · Columbia X-Rds, PANTSB NYC67A0076Accident · No injuriesClosedPiper PA-30 · New Cumberland, PANTSB NYC67I0074Incident · No injuriesClosedViscount 745D · Pittsburg, PANTSB NYC67F0341Accident · No injuriesClosedCessna 140 · Danville, PANTSB NYC67F0317Accident · Minor injuriesClosedPiper PA-12 · Clarks Summit, PANTSB NYC67D0373Accident · No injuriesClosedMooney M20E · Grove City, PANTSB NYC67F0355Accident · No injuriesClosedBeechcraft E18S · Reedsville, PANTSB NYC67F0326Accident · No injuriesClosedPiper PA-30 · Morrisville, PANTSB NYC67D0375Accident · Minor injuriesClosedPiper PA-22 · Erie, PANTSB NYC67A0064Accident · No injuriesClosedBrantly 305 · West Mifflin, PANTSB NYC67D0365Accident · No injuriesClosedStinson 108-1 · Leechburg, PANTSB NYC67A0106Accident · No injuriesClosedHiller UH-12A · Honesdale, PANTSB NYC67F0300Accident · No injuriesClosedCessna 150 · Carlisle, PANTSB NYC67D0323Accident · No injuriesClosedPiper PA-20 · Finleyville, PANTSB NYC67F0280Accident · No injuriesClosedMooney M20E · Avoca, PANTSB NYC67F0252Accident · No injuriesClosedCessna 337 · Ohnstown, PANTSB NYC67D0366Accident · No injuriesClosedPiper PA-28 · Johnston, PANTSB NYC67A0052Accident · 1 fatalClosedBensen B8M · Benton, PANTSB NYC67F0244Accident · Serious injuriesClosedCessna 180 · Tarentum, PANTSB NYC67F0189Accident · No injuriesClosedCessna 180 · Freedom, PANTSB NYC67F0271Accident · Serious injuriesClosedCessna 182 · Clarion, PANTSB NYC67F0206Accident · No injuriesClosedCessna 182A · Pottstown, PANTSB NYC67F0176Accident · No injuriesClosedMooney MK20A · Allentown, PANTSB NYC67D0246Accident · No injuriesClosedMooney M20C · Philadelphia, PANTSB NYC67F0230Accident · Minor injuriesClosedPiper PA-22 · Milroy, PANTSB NYC67A0041Accident · No injuriesClosedHughes 269A · Montoursville, PANTSB NYC67F0190Accident · No injuriesClosedPiper PA-28 · West Mifflin, PANTSB NYC67F0247Accident · No injuriesClosedCessna 172B · Annville, PA