NTSB investigations, 1977, ME
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
| 1962 | 1 |
|---|---|
| 1964 | 27 |
| 1965 | 19 |
| 1966 | 34 |
| 1967 | 29 |
| 1968 | 38 |
| 1969 | 17 |
| 1970 | 13 |
| 1971 | 28 |
| 1972 | 40 |
| 1973 | 32 |
| 1974 | 23 |
| 1975 | 25 |
| 1976 | 26 |
| 1977 | 32 |
| 1978 | 25 |
| 1979 | 27 |
| 1980 | 21 |
| 1981 | 17 |
| 1982 | 18 |
| 1983 | 17 |
| 1984 | 22 |
| 1985 | 15 |
| 1986 | 16 |
| 1987 | 14 |
| 1988 | 15 |
| 1989 | 16 |
| 1990 | 12 |
| 1991 | 19 |
| 1992 | 20 |
| 1993 | 22 |
| 1994 | 19 |
| 1995 | 12 |
| 1996 | 14 |
| 1997 | 7 |
| 1998 | 10 |
| 1999 | 13 |
| 2000 | 12 |
| 2001 | 15 |
| 2002 | 10 |
| 2003 | 10 |
| 2004 | 12 |
| 2005 | 9 |
| 2006 | 14 |
| 2007 | 9 |
| 2008 | 13 |
| 2009 | 14 |
| 2010 | 10 |
| 2011 | 16 |
| 2012 | 11 |
| 2013 | 8 |
| 2014 | 8 |
| 2015 | 4 |
| 2016 | 7 |
| 2017 | 8 |
| 2018 | 4 |
| 2019 | 11 |
| 2020 | 6 |
| 2021 | 3 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 9 |
| 2025 | 8 |
| 2026 | 9 |
Where
Open the mapLatest 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\") = 1977
AND c.\"eventStateOrRegion\" = 'ME' 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") = 1977 AND c."eventStateOrRegion" = 'ME' 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 NYC78DNC11Accident · No injuriesClosedCessna 172M · Harbor, MENTSB NYC78FA012Accident · 2 fatalClosedTaylorcraft BC12-D · Mercer, MENTSB NYC78FNC04Accident · No injuriesClosedRepublic UC1 · Harbor, MENTSB NYC78FNC01Accident · No injuriesClosedPiper PA-20 · Norridgewock, MENTSB NYC77DNC56Accident · No injuriesClosedCessna 172 · Brunswick, MENTSB NYC77FNC55Accident · No injuriesClosedStinson 108-3 · Saco, MENTSB NYC77FA096Accident · 1 fatalClosedLake LA-4 · Greenville, MENTSB NYC77FNC52Accident · No injuriesClosedPiper PA-20 · Thomaston, MENTSB NYC77FNC51Accident · Minor injuriesClosedCessna A185E · Patten, MENTSB NYC77DNC49Accident · Minor injuriesClosedCessna 177 · Hope, MENTSB NYC77FNC53Accident · No injuriesClosedTaylorcraft BC-65 · West Lebanon, MENTSB NYC77DNC47Accident · No injuriesClosedCessna 150 · Belfast, MENTSB NYC77FNC46Accident · No injuriesClosedStearman C3-R · Rockland, MENTSB NYC77FNC45Accident · No injuriesClosedCessna 120 · Limerick, MENTSB NYC77DNC44Accident · No injuriesClosedCessna 337 · Bingham, MENTSB NYC77FNC43Accident · 1 fatalClosedBellanca 7GCBC · Ft Fairfield, MENTSB NYC77FNC41Accident · No injuriesClosedCessna 150H · Standish, MENTSB NYC77FA073Accident · No injuriesClosedPiper PA-23 · Rockland, MENTSB NYC77DNC42Accident · No injuriesClosedPiper PA-28 · Old Town, MENTSB NYC77FNC37Accident · Serious injuriesClosedCessna 150K · Waldoboro, MENTSB NYC77DNC33Accident · No injuriesClosedCessna 172 · Vinalhaven, MENTSB NYC77FA062Accident · 3 fatalClosedCessna 182F · Oxbow, MENTSB NYC77FNC31Accident · No injuriesClosedCessna 172N · Princeton, MENTSB NYC77DNC28Accident · Minor injuriesClosedPiper PA-22 · Montville, MENTSB NYC77DNC26Accident · Minor injuriesClosedCessna 150M · Richmond Is, MENTSB NYC77DNC27Accident · No injuriesClosedPiper PA-34 · Presque Isle, MENTSB NYC77DNC24Accident · No injuriesClosedBeech B19 · Machias, MENTSB NYC77FNC23Accident · No injuriesClosedCessna 182P · Stonington, MENTSB NYC77DNC21Accident · No injuriesClosedCessna 414 · Carabasset, MENTSB NYC77FNC17Accident · Serious injuriesClosedCessna 172 · Caribu, MENTSB NYC77DNC18Accident · No injuriesClosedCessna 172 · Abbott Village, MENTSB NYC77DNC15Accident · No injuriesClosedPiper PA-28 · Bar Harbor, ME