NTSB investigations, 1967, 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\") = 1967
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") = 1967 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 NYC68F0267Accident · No injuriesClosedTaylorcraft BC12D1 · Waterville, MENTSB NYC68A0061Accident · 1 fatalClosedRepublic RC-3 · Ashland, MENTSB NYC68F0203Accident · No injuriesClosedPiper PA-28 · Auburn, MENTSB NYC68D0229Accident · No injuriesClosedAeronca 7DC · Augusta, MENTSB NYC68D0146Accident · No injuriesClosedCessna 180 · The Forks, MENTSB NYC68A0039Accident · Minor injuriesClosedBell 47G-5 · Westfield, MENTSB NYC68F0124Accident · No injuriesClosedPiper PA-20S · Bucksport, MENTSB NYC68D0129Accident · No injuriesClosedPiper PA-20 · Waterville, MENTSB NYC68D0145Accident · No injuriesClosedTaylorcraft BC12-D · Bethel, MENTSB NYC68D0117Accident · No injuriesClosedPiper PA-22 · Augusta, MENTSB NYC68F0095Accident · No injuriesClosedMeyers 200-C · Portland, MENTSB NYC68A0009Accident · 4 fatalClosedPiper PA-12 · Soldier Pond, MENTSB NYC68D0077Accident · Minor injuriesClosedCessna 172 · Millinocket, MENTSB NYC68A0001Accident · 5 fatalClosedRepublic RC-3 · Searsport, MENTSB NYC68D0086Accident · Minor injuriesClosedPiper PA-28 · Lincolnville, MENTSB NYC68D0073Accident · No injuriesClosedCessna 150 · Presque Isle, MENTSB NYC68D0016Accident · Minor injuriesClosedCessna 172G · Sherman, MENTSB NYC67F0671Accident · No injuriesClosedCessna 172 · Caribou, MENTSB NYC67I0167Incident · Serious injuriesClosedBensen B8 · Deblois, MENTSB NYC67F0652Accident · No injuriesClosedPiper PA-22 · Old Town, MENTSB NYC67D0633Accident · No injuriesClosedAeronca 65-TAC · Turner, MENTSB NYC67F0577Accident · No injuriesClosedPiper PA-22 · Old Town, MENTSB NYC67D0550Accident · No injuriesClosedTaylorcraft BC12-D · Roxbury, MENTSB NYC67D0549Accident · No injuriesClosedPiper PA-12 · Fairfield, MENTSB NYC67D0512Accident · No injuriesClosedPiper PA-28 · Old Town, MENTSB NYC67F0523Accident · No injuriesClosedCessna 140 · Old Town, MENTSB NYC67F0496Accident · No injuriesClosedLuscombe 8A · Auburn, MENTSB NYC67D0536Accident · No injuriesClosedCessna 180 · Greenville, MENTSB NYC67F0422Accident · Minor injuriesClosedAeronca 11AC · Pittsfield, ME