NTSB investigations, 1973, 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\") = 1973
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") = 1973 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 NYC74FNC31Accident · Serious injuriesClosedCessna 172M · Rangeley, MENTSB NYC74FNC28Accident · Minor injuriesClosedBowers Fly Baby · South Paris, MENTSB NYC74AN042Accident · 2 fatalClosedPiper PA-28 · Allagash, MENTSB NYC74DNC17Accident · No injuriesClosedCessna 150G · Wiscasset, MENTSB NYC74FNC14Accident · Serious injuriesClosedTaylorcraft BC12-D · Greenville, MENTSB NYC74AN011Accident · No injuriesClosedCessna 402 · Bar Harbor, MENTSB NYC74DNC11Accident · Minor injuriesClosedPiper PA-22 · Lubec, MENTSB NYC74DNC13Accident · Minor injuriesClosedAmer Avco AA-1A · Alton, MENTSB NYC74FNC12Accident · No injuriesClosedLake LA-4 · Bethel, MENTSB NYC74DNC09Accident · No injuriesClosedCessna 180 · Greenville, MENTSB NYC74FNC06Accident · No injuriesClosedLuscombe 8F · Trenton, MENTSB NYC74DNC07Accident · Minor injuriesClosedBell 47G · Weld, MENTSB NYC74FNC03Accident · No injuriesClosedBoeing A75 · South Hope, MENTSB NYC74FNC02Accident · Serious injuriesClosedPiper PA-28 · Buxton, MENTSB NYC74FNC01Accident · 1 fatalClosedSnow 600S2C · Presque Isle, MENTSB NYC73AN155Accident · 2 fatalClosedPiper PA-23 · Princeton, MENTSB NYC73AN153Accident · Serious injuriesClosedDouglas DC-8 · Bangor, MENTSB NYC73DNG75Accident · No injuriesClosedGrumman TBM-3E · Fort Kent, MENTSB NYC73FNC73Accident · No injuriesClosedPiper J3-65 · Augusta, MENTSB NYC73AN141Accident · 6 fatalClosedCessna 402B · Greenville, MENTSB NYC73FNC69Accident · No injuriesClosedCessna 150 · Norridgewock, MENTSB NYC73DNC70Accident · Minor injuriesClosedLuscombe 8A · Princeton, MENTSB NYC73DNC66Accident · No injuriesClosedCessna 172L · Carrabassett, MENTSB NYC73DNC64Accident · No injuriesClosedCessna 120 · Rangely, MENTSB NYC73DNC65Accident · No injuriesClosedPiper PA-28 · Bangor, MENTSB NYC73AN122Accident · 2 fatalClosedBeech 65-A90 · Portland, MENTSB NYC73DNC58Accident · No injuriesClosedPiper PA-28 · Machias, MENTSB NYC73DNC54Accident · No injuriesClosedMooney M20E · Biddeford, MENTSB NYC73DNC60Accident · No injuriesClosedCessna 150 · Eastport, MENTSB NYC73DNC53Accident · No injuriesClosedLuscombe 8E · Meddybemps, MENTSB NYC73FNC52Accident · No injuriesClosedMooney M20F · Caribou, MENTSB NYC73ANC47Accident · No injuriesClosedCessna 310D · Brewer, ME