NTSB investigations, 1986, 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
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\") = 1986
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") = 1986 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 NYC87DNC04Accident · Serious injuriesFinal reportTaylorcraft BC12D · West Farmington, METhe aircraft climbed in a steep attitude after takeoff to an alt of aprx 100 ft AGL. The acft then stalled and impacted the terrain in a left wing low attitude.NTSB NYC87LA046Accident · No injuriesLimited investigationFinal reportBeech B23 · Trenton, METhe plt rprtd that after takeoff, the acft had climbed to 600 ft & was climbing at 300 ft/min, when the eng 'started to labor,' then quit running. He used carburetor heat & 'primed through power reduction,' but the eng would not restart. During an emerg lndg…NTSB NYC87LA034Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Jackman, METhe pilot attempted a landing on a runway marked with a x. the runway was closed because it had been extended and was very close to some powerlines. The pilot hit the power lines on final and the aircraft received substantial damage. The pilot was seriously…NTSB NYC87IA014Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Portland, METhe cp was flying the aircraft from the left seat while being observed by the PIC. The PIC was monitoring the approach, which was being made in IMC conditions and noted the aircraft drifting to the left, the cp started to make correction to the right at which…NTSB NYC87FA015Accident · 1 fatalField investigationFinal reportCessna 185 · Greenville, METh plt stated that the acft encountered crosswinds of 20 KTS gusting to 30 KTS as the acft was coming off the step during liftoff in the open lake. The acft's right wing was forced down, the right float struck the water which resulted in the right wing…NTSB NYC87DNC02Accident · No injuriesFinal reportCessna 172M · Van Buren, MEWhile climbing from 1000 ft. the pilot of a C-172 expericed an engine failure at 1500 ft and made an emergency landing striking small trees and brush. Subsequent inspection of the engine revealed that the crankshaft dowel pin was sheared and the crankshaft…NTSB NYC87LA003Accident · No injuriesLimited investigationFinal reportCessna 150 · Buxton, METhe pilot was making a short field landing at a private airstrip which was grass covered and wet. The pilot came in too high and long and once on the ground, skidded to a stop between two trees.NTSB NYC86LA226Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · So. Berwick, METhe acft experienced a loss of eng power while leveling off at 2,500 ft MSL shortly after takeoff. Remedial action was attempted, however, power was not regained. The plt initiated a 180 deg turn back toward the arpt but altitude was insufficient to reach the…NTSB ATL86FA235Accident · 2 fatalField investigationFinal reportPiper PA-18 · Wilton, MEWitnesses saw the acft go into a nose down attitude prior to crashing into a wooded area near the arpt. Rprtdly, the prop was turning, but no sound was heard from the eng. Subsequently, the acft impacted the gnd in a nose low, inverted attitude. No preimpact…NTSB NYC86FNC05Accident · Minor injuriesFinal reportBell 47G-5 · Walthamer, MEWhile on a spray run the pilot of the Bell 47 was blinded by the sun as he was turning. The aircraft struck power lines, control was lost and the helicopter crashed.NTSB NYC86LA149Accident · No injuriesLimited investigationFinal reportCessna U206 · Presque Isle, MEAccording to the plt, the eng lost power about 10 min after he took off while flying at low altitude. He landed in a field that was surrounded by trees. Drg the landing, the rgt float, rgt wing & rgt side of the empennage were damaged. No reason was found for…NTSB NYC86LA130Accident · No injuriesLimited investigationFinal reportCessna 206 · Greenville, METhe pilot experienced problems on takeoff from moosehead lake, but eventually was able to get airborne and fly to the Greenville airport. The aircraft remained on the ground for a few hours, then was preflighted for deparapure. Runway 21 was the favorable…NTSB NYC86LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hampden, MEAfter taking off, the plt initiated a climb & leveled off at 2500'. As he reduced power to cruise, the eng stopped running. All attempts to restart the eng were unsuccessful. Subsequently, the acft was damaged when the plt landed on rocky pasture land. Fuel…NTSB NYC86FNC02Accident · Serious injuriesFinal reportPiper PA-11 · Brewer, METhe plt had been using auto gas in this acft, however, he experienced water contamination problems and discontinued its use. He then found himself at an arpt needing fuel. The arpt only had auto gas available so the plt refueled the acft with auto gas. While…NTSB NYC86LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Springvale, METhe Piper cherokee PA-28-140 lost power and made an off airport landing 15 minutes after takeoff. The pilot reported an oil line broke and he lost all engine oil. A mechanic reported that there was no indication in either the engine compartment or the bottom…NTSB NYC86LA085Accident · Minor injuriesLimited investigationFinal reportRockwell 680FL · Houlton, METhe pilot-in-command landed on runway 5 which had approximately 1 inch of fresh snow. He reported that he encountered whiteout conditions during the landing & lost reference to the runway centerline. The aircraft touched down on the left side of the runway,…