NTSB investigations, 1976, PA
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1976
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") = 1976 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 NYC77FGT05Accident · No injuriesClosedCessna 150 · Philipsburg, PANTSB NYC77FA023Accident · Serious injuriesClosedConvair 580 · Bradford, PANTSB NYC77FHA09Accident · Minor injuriesClosedPiper PA-28 · Claussville, PANTSB NYC77FGM07Accident · No injuriesClosedCessna 340 · Belle Vernon, PANTSB NYC77FGT06Accident · No injuriesClosedCessna 177B · Mifflintown, PANTSB NYC77FGM08Accident · No injuriesClosedPiper PA-32 · Ligonier, PANTSB NYC77FGM06Accident · No injuriesClosedBeech B19 · Belle Vernon, PANTSB NYC77FGM05Accident · No injuriesClosedPiper PA-24 · Monongahela, PANTSB NYC77FGM04Accident · Serious injuriesClosedPiper PA-24 · Smithfield, PANTSB NYC77IA020Incident · No injuriesClosedBoeing 727 · Philadelphia, PANTSB NYC77FGT03Accident · Minor injuriesClosedStits SA3B · Lititz, PANTSB NYC77FHA05Accident · Serious injuriesClosedBellanca 17-31A · Barto, PANTSB NYC77FGT04Accident · Minor injuriesClosedPiper PA-28 · Philipsburg, PANTSB NYC77FGT02Accident · No injuriesClosedChampion 7GCAA · Anneville, PANTSB NYC77FHD04Accident · No injuriesClosedPiper PA-22 · Bristol, PANTSB NYC77FA014Accident · 1 fatalClosedCessna 172M · Conneautville, PANTSB NYC77DHA06Accident · No injuriesClosedChampion 7ECA · Dalton, PANTSB NYC77FA012Accident · 1 fatalClosedPiper PA-22 · Warren Center, PANTSB NYC77FHA04Accident · Minor injuriesClosedAeronca 11AC · Hazleton, PANTSB NYC77FA004Accident · 4 fatalClosedPiper PA-28 · Elizabethville, PANTSB NYC77FA005Accident · 1 fatalClosedPiper PA-28 · Frenchville, PANTSB NYC77FHD01Accident · No injuriesClosedCessna 150 · West Chester, PANTSB NYC77FHA01Accident · Serious injuriesClosedBellanca 7GCBC · Center Square, PANTSB NYC77FGM02Accident · Serious injuriesClosedBellanca 14-19 · Fort Littleton, PANTSB NYC77DHA08Accident · No injuriesClosedPiper PA-28R · Shultzville, PANTSB NYC76FHA02Accident · Serious injuriesClosedCessna 170B · Analomink, PANTSB NYC77FA003Accident · 1 fatalClosedAeronca 15AC · Erwinna, PANTSB NYC77DGM01Accident · Minor injuriesClosedPiper PA-18 · Emporium, PANTSB NYC77FGT01Accident · No injuriesClosedN. American AT-6C · Port Matilda, PANTSB NYC77FA001Accident · 2 fatalClosedBeech E55 · Bradford, PANTSB NYC76FGM53Accident · Minor injuriesClosedPiper PA-32 · Indiana, PANTSB NYC76FGM52Accident · No injuriesClosedCessna 150F · Cooperstown, PANTSB NYC76FGM51Accident · Minor injuriesClosedBeech A35 · North East, PANTSB NYC76FGM50Accident · No injuriesClosedCessna 150L · Beaver Falls, PANTSB NYC76FGM49Accident · No injuriesClosedBeech G18S · Beaver Falls, PANTSB NYC76FHA55Accident · No injuriesClosedBrantly 305 · Telford, PANTSB NYC76FHA54Accident · No injuriesClosedBellanca 17-30 · Allentown, PANTSB NYC76IN125Incident · Minor injuriesClosedDehavilland DHC-6 · Franklin, PANTSB NYC76DHA53Accident · No injuriesClosedLuscombe 8A · Sterling, PANTSB NYC76FHA51Accident · No injuriesClosedErco 415-CD · Jamison, PANTSB NYC76DHD44Accident · No injuriesClosedCessna 150J · Blue Bell, PANTSB NYC76DHA52Accident · No injuriesClosedPiper PA-28 · Prospectville, PANTSB NYC76FGM48Accident · No injuriesClosedPiper PA-28 · Mount Pleasant, PANTSB NYC76FGT76Accident · Serious injuriesClosedBowers Fly Baby · Kralltown, PANTSB NYC76FHA50Accident · No injuriesClosedGrum Amer AA-5 · Allentown, PANTSB NYC76DHA49Accident · Minor injuriesClosedSchweizer SGS126 · Erwinna, PANTSB NYC76DGM46Accident · Minor injuriesClosedPiper PA-22 · Zelienople, PANTSB NYC76FGT28Accident · No injuriesClosedPiper PA-28 · Lock Haven, PANTSB NYC76FGT27Accident · No injuriesClosedBell 47D1 · Zion Grove, PANTSB NYC76AN123Accident · 1 fatalClosedAeronca 11BC · Bally, PA