NTSB investigations, 2006, 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\") = 2006
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") = 2006 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 NYC07LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Livermore Falls, METhe pilot's failure to maintain directional control during landing, which resulted in a groundloop.NTSB NYC06LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Orient, METhe pilot's failure to maintain adequate airspeed during the initial climb which resulted in an inadvertent stall. A factor was his inadequate weight and balance calculations and the gusty wind conditions.NTSB NYC06IA226Incident · No injuriesIncident investigationFinal reportCessna 206F · Matinicus Islnd, MEAn engine kick back of undetermined origin during engine start.NTSB NYC06LA157Accident · Serious injuriesLimited investigationFinal reportWorcester Everett Renegade II · Orneville, MEA loss of engine power for an undetermined reason.NTSB NYC06FA154Accident · 4 fatalField investigationFinal reportCessna 172N · Newry, METhe flight instructor's failure to maintain altitude/clearance while maneuvering, which resulted in an impact with trees.NTSB NYC06CA146Accident · Serious injuriesData collectionFinal reportTheordore Jankowski Rans S-12 · Caribou, METhe pilot's failure to maintain directional control which resulted in a subsequent impact with trees. A factor in the accident was the unmowed area of vegetation.NTSB NYC06CA140Accident · No injuriesData collectionFinal reportCessna A185E · Turner, METhe pilot's failure to obtain the proper touchdown point, resulting in a runway undershoot, and substantial damage to the airplane.NTSB NYC06CA126Accident · No injuriesData collectionFinal reportPiper J3C · Old Town, METhe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with water.NTSB NYC06CA125Accident · No injuriesData collectionFinal reportRobinson R-22 · Sanford, METhe flight instructor's inadvertent encounter with settling-with-power, which resulted in a hard landing, and subsequent roll-over. A factor in the accident was the tailwind.NTSB NYC06LA091Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Passadumkeag, METhe partially blocked fuel line, which resulted in fuel starvation and a subsequent loss of engine power. Factors in the accident included inadequate maintenance, and the unsuitable terrain.NTSB NYC06CA084Accident · No injuriesData collectionFinal reportCessna 180F · Greenville, METhe pilot's failure to maintain directional control during landing, resulting in a ground loop. A factor was the rough/uneven runway condition.NTSB NYC06LA070Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Dover-Foxcroft, METhe pilot's inadequate preflight inspection, which failed to detect ice in the fuel system, resulting in a loss of engine power during takeoff-initial climb, and an in-flight collision with trees.NTSB NYC06CA069Accident · No injuriesData collectionFinal reportCessna 152 · Augusta, METhe pilot's improper flare, which resulted in a hard landing.NTSB NYC06CA060Accident · No injuriesData collectionFinal reportCessna 305A · Seboeis, METhe pilot's failure to maintain clearance from power lines, while attempting to land on a frozen lake.