NTSB investigations, 1991, ME
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
| 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\") = 1991
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") = 1991 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 NYC92LA036Accident · No injuriesLimited investigationFinal reportPiper PA-31-T1040 · Portland, METhe excessive fuel pressure during inflight fuel transferring, which resulted in the rupture of the wing tank and subsequent damage to the wing. Also causal to the accident was the inadequate fuel tank vent system and the inaccurate fuel quantity system.NTSB NYC92LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Sanford, METhe failure of the nose wheel through bolt as a result of fatigue cracking.NTSB NYC92LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Lincoln, METhe pilot's failure to see and avoid the transmission lines. A factor was the sunglare.NTSB NYC92LA002Accident · Minor injuriesLimited investigationFinal reportFairchild SA-227AC · Augusta, METhe copilot's failure to attain a proper touchdown point. Factors were the captain's failure to follow company procedure and both pilot's limited experience.NTSB NYC92LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Auburn, METhe pilot was buzzing and stalled the airplane at too low an altitude to recover.NTSB NYC91LA243Accident · No injuriesLimited investigationFinal reportLake LA-4 · Wilton, METhe pilot's improper recovery from a bounced landing on rough water which resulted in the right wing tip contacting the water causing the airplane to nose over and sink. Factors related to the accident were, the pilot's low time and experience in this type…NTSB NYC91LA231Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC/2D · Rangeley, MEImproper takeoff planning by the pilot which resulted in an inflight collision with trees during initial climb. A factor related to the accident was the pilot's decision not to use the full lake surface available for takeoff.NTSB NYC91LA223Accident · No injuriesLimited investigationFinal reportCessna 150 · Ashland, METhe pilot's premature liftoff. Factors were the rough airstrip and the soft terrain encountered during landing.NTSB NYC91LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Greenville, MEInadequate compensation for gusting winds by the pilot-in-command.NTSB NYC91FA188Accident · Serious injuriesField investigationFinal reportCessna 172M · Phillips, MEAn inadvertent stall and loss of control due to the pilot's improper use of the wing flaps for takeoff. Factors related to the accident were: the pilot's misunderstanding of airplane performance, and the pilot's decision to takeoff uphill.NTSB NYC91LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Eagle Lake, METhe pilot's misjudgment of his altitude during a landing on glassy water, which resulted in a loss of airplane control.NTSB NYC91LA156Accident · No injuriesLimited investigationFinal reportBoeing PT-17A75N1 · Limington, METhe improper handling of the airplane while taxiing, which resulted in a loss of control. A factor was the limited experience of the pilot in this model.NTSB NYC91FA154Accident · 2 fatalField investigationFinal reportAeronca 7BCM · Millinocket, MEFailure of the pilot to maintain adequate airspeed, while maneuvering for a precautionary landing on a road, which resulted in an inadvertent stall. Factors related to the accident were: the pilot's improper replacement of an oil temperature gage, and a…NTSB NYC91LA139Accident · No injuriesLimited investigationFinal reportBeech BE-23-B24R · Caribou, METhe failure of the engine driven fuel pump, which resulted in a total loss of engine power and subsequent forced landing on rough terrain. Factors related to the accident were the decision by the pilot to takeoff with known mechanical deficiencies; the…NTSB NYC91LA234Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Sanford, METhe pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation and a forced landing in trees.NTSB NYC91LA110Accident · No injuriesLimited investigationFinal reportCessna 182F · Carrabassett Vy, MEImproper use of the carburetor heat by the pilot which resulted in a power loss due to carburetor ice over unsuitable terrain.NTSB NYC91LA096Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bar Harbor, METhe engine lost power for an undetermined reason.NTSB NYC91LA092Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Westbrook, MEImproper emergency procedures by the pilot. Factors related to the accident were: the pilot's lack of experience and flight time in type of airplane, the pilots decision to take an airplane with a known mechanical defect, a leaky accelerator pump seal on the…NTSB NYC91FA069Accident · 3 fatalField investigationFinal reportCessna 172P · Augusta, METhe pilot rotated the airplane at an improper speed, then allowed the climb angle to become too steep, causing an inadvertent stall at too low an altitude to allow recovery. Contributing factors in the accident were; the pilot failed to use all of the…