NTSB investigations, 1988, 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
Latest 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\") = 1988
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") = 1988 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 NYC89LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Wiscasset, METhe plt lost control during an attempted go-around, and collided with trees off the side of the runway. The pilot said that a gust of wind turned the acft 45 degrees to the runway on landing roll, and during the attempted go-around he hit tree tops off to the…NTSB NYC89LA051Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stacyville, METhe student pilot became lost during a cross country flt. The flight was continued until the acft ran out of fuel. The aircraft collided with trees during an emergency landing and nosed over. The plt told the state police at the acc site that the acft had run…NTSB NYC88LA244Accident · No injuriesLimited investigationFinal reportCessna 177 · Machias, METhe plt was practicing night takeoffs and landings. He stated that he had successfully accomplished two full stop landings. After the third landing, he applied full power to execute a go-around. The pilot said the airplane pulled to the left so he reduced the…NTSB NYC88FA235Accident · 3 fatalField investigationFinal reportCessna 182RG · Greenville, METhe non-instrument rated pilot apparently could not locate the destination airport because of low ceilings and ground fog. Before the pilot started his trip he was advised by the fss that VFR flight to his destination was not recommended. It appears that the…NTSB NYC88FA218Accident · 1 fatalField investigationFinal reportCessna 172K · Island Falls, MEPilot's poor in-inflight decisions and planning and failed to follow ATC directives to maintain VFR. The pilot continued VFR into IFR conditions and collided with hilly terrain.NTSB NYC88LA214Accident · Minor injuriesLimited investigationFinal reportBell 47G5 · Biddeford, METhe helicopter made an approach to a low hover above a hard surfaced rwy. The helicopter was slowly air taxiing when the plt felt the helicopter become unstable directionally and he considered making a run-on landing. However, before he could make the landing…NTSB NYC88LA209Accident · No injuriesLimited investigationFinal reportBell 47G3B-1 · Oakland, MEDuring an aerial photography flt, the pilot was maneuvering at 30 ft, at 25 mph and making a right turn over a lake when the nose of the helicopter swung to the right unexpectedly. He stated that 'when the aircraft entered the unexpected swing to the right I…NTSB NYC88LA208Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Auburn-Lewiston, METhe student pilot of an Ercoupe 415C hand-propped the aircraft with no one at the controls and the tail not tied down. The engine started and the Ercoupe struck a parked, unoccupied, tied down Cessna 170.NTSB NYC88LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Fryeburg, MEAccording to witnesses, the pilot had been drinking and two friends drove him to the airport and watched as he departed. They noted that the aircraft was climbing steeply after liftoff and then observed the aircraft's rotating beacon as the aircraft spiraled…NTSB NYC88LA171Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Steep Falls, METhe Ercoupe 415C took off to practice touch and go's with a student pilot in the left seat and on the controls. In the right seat was a private pilot who was listed as a pilot rated passenger. Both occupants were co-owners of the aircraft. The student pilot…NTSB NYC88FA167Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Livermore Falls, METhe citabria 7GCBC was observed to make a loop. The left wing bent upward at the strut attach point as the aircraft was at the bottom of the loop and recovering to level flight. The aircraft was then observed to descend in a right spiral and not recover prior…NTSB NYC88LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · W. Peru, METhe cockpit of the Piper PA-28 filled with smoke after takeoff, at an altitude of approximately 800 ft. the pilot tried to land on a road and struck trees, shearing off the wings. The fuselage landed on a road, inverted and was immediately enfulfed in flames.…NTSB NYC88LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Turner, METhe pilot said he preflighted the aircraft before departure. The pilot stated that he flew in the local area taking photos, then had started back towards the airport when the engine began to sputter. The pilot called bangor air rescue, checked instruments and…NTSB NYC88LA106Accident · No injuriesLimited investigationFinal reportCessna 172 · Old Town, MEFollowing rollout from a normal landing in strong winds, and during a left turn onto the taxiway, the wing of the aircraft was lifted up by a quartering tailwind and flipped over.NTSB NYC88LA071Accident · No injuriesLimited investigationFinal reportCessna 402B · Bangor, METhe crew rprtd that drg takeoff, a power surge occurred after the acft had climbed about 400 to 500 ft. the coplt saw what he later said was a right fuel flow fluctuation & told the plt (PIC) that the right eng was losing power. The PIC told the coplt to…