Skip to content

NTSB investigations, ME

24 cases where the first occurrence was “In flight collision with terrain/water”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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 c."eventStateOrRegion" = 'ME' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 c.\"eventStateOrRegion\" = 'ME' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
  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 c."eventStateOrRegion" = 'ME' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230)
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 MIA07CA095Accident · Minor injuriesData collectionFinal reportCessna 172-M · Oxford, METhe student pilot's failure to maintain a climb during a go-around resulting in collision with an embankment.May 8, 2007 · N80132 · Substantial damage NTSB IAD03FA004Accident · 1 fatalField investigationFinal reportCessna 182S · Brownville Jct, METhe pilot's failure to maintain sufficient altitude while flying in mountainous terrain at night. A factor was the night lighting conditions.Oct 12, 2002 · N100TY · Destroyed NTSB NYC01FA058Accident · 2 fatalField investigationFinal reportBeech B200 · Rangeley, METhe pilot-in-command's failure to maintain sufficient altitude while maneuvering to land, which resulted in a collision with terrain. Factors in the accident were the dark night, mountainous terrain, snow showers, clouds, and the pilot's decision to cancel…Dec 22, 2000 · N30EM · Destroyed NTSB NYC00LA265Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Greenville, METhe pilot's improper in-flight decision to continue his descent without visual contact with the runway, and his inattention to his altitude, in relation to the airport elevation.Sep 23, 2000 · N590TA · Substantial damage NTSB NYC00LA025Accident · Serious injuriesLimited investigationFinal reportKnox HI-MAX · Dixfield, METhe pilot's failure to obtain the proper touchdown point. A factor in the accident was the pilot's lack of experience in make and model.Nov 5, 1999 · N63307 · Substantial damage NTSB NYC99LA237Accident · No injuriesLimited investigationFinal reportPratt Dominator · Auburn, METhe pilot's improper decision to execute a 0 airspeed pedal turn at 100 feet agl.Sep 25, 1999 · N4449N · Substantial damage NTSB NYC98FA071Accident · 2 fatalField investigationFinal reportPiper PA-31-310 · Presque Isle, METhe pilot's failure to follow the published instrument approach procedure and his descent below the minimum descent altitude. Contributing factors were the night conditions, low ceilings, and fog.Mar 1, 1998 · N777HM · Destroyed NTSB NYC96LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Auburn, METhe pilot's improper planning/decision and failure to attain proper alignment with the landing area. Factors relating to the accident were: darkness, and the inoperative radio transmitter, which precluded the pilot from activating the runway lights.Jan 16, 1996 · N913A · Substantial damage NTSB BFO95LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Belfast, MEthe student pilot's failure to adequately compensate for wind conditions. A related factor was the presence of high snowbanks along the sides of the runway.Mar 4, 1995 · N5554Z · Substantial damage NTSB BFO94FA134Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Grand Lake Strm, METhe pilot attempted a maneuver at an altitude insufficient for recovery. A factor in the accident was pilot physical impairment due to alcohol consumption.Aug 12, 1994 · N8588Y · Destroyed NTSB NYC93LA150Accident · No injuriesLimited investigationFinal reportErco 415D · Thomaston, METhe improper weather evaluation by the non-instrument-rated pilot, and the subsequent VFR flight into instrument meteorologial conditions, resulting in a collision with the terrain.Aug 11, 1993 · CFJUB · Substantial damage NTSB BFO92LA150Accident · 2 fatalLimited investigationFinal reportPiper PA-28-160 · Bethel, METhe pilot's failure to maintain adequate altitude to avoid the terrain. The dark night was a factor.Sep 26, 1992 · N5867W · Destroyed NTSB BFO92FA127Accident · 1 fatalField investigationFinal reportCessna A150L · Troy, MEFailure of the pilot to maintain proper altitude during an aerobatic manuever.Sep 5, 1992 · N6054J · Destroyed NTSB NYC92LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Auburn, METhe pilot was buzzing and stalled the airplane at too low an altitude to recover.Oct 4, 1991 · N2065E · Substantial damage NTSB NYC90FA227Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Eliot, METhe pilot's failure to abort the takeoff. Factors were the over weight condition, upsloping runway, premature rotation, and the pilot's lack of experience in type aircraft and general aviation operations.Sep 23, 1990 · N8664P · Destroyed NTSB NYC90FA135Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Greenville, MEFailure of the pilot to maintain the proper altitude, while searching for the destination airport at night. Factors related to the accident were: darkness, fog obscuring the destination airport lights, mountainous terrain, and the lack of visual perception at…Jun 19, 1990 · N44897 · Destroyed NTSB NYC90LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Bingham, METhe pilot's inadequate preflight planning to assure that the airplane was capable of outclimbing the surrounding terrain under the existing wind and airplane weight conditions, resulting in an intentional stall into the terrain. Contributing factor(s) was:…Oct 1, 1989 · N89219 · Destroyed NTSB NYC89FA121Accident · 1 fatalField investigationFinal reportBeech B19 · Augusta, MEFailure of the pilot to maintain the proper altitude during the approach. A factor related to the accident was: the pilot's psychological condition.Apr 19, 1989 · N2231L · Destroyed 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.Aug 15, 1988 · N1183M · Destroyed NTSB NYC84LA316Accident · No injuriesLimited investigationFinal reportCessna 182H · Stonington, MEPlt was delayed in return flt to home arpt and arrived at the unlighted strip in darkness. The plt misjudged his runway alignment on approach, colliding with trees 15 ft from the runway during the landing flare.Sep 18, 1984 · N2052X · Destroyed NTSB NYC84FA189Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · South Paris, MEBefore the accident, the plt was last seen on 3/9/84 at 1530 EST & had not expressed any intentions of flying. At 1730, his car was located at the arpt & his acft, which had been kept there, was gone. The acft was found on 5/24/84 where it had crashed on…Mar 9, 1984 · N95040 · Destroyed NTSB NYC84LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Great Pond, METhe plt stated that he was going hunting in a bog with a stream running thru the area. Reportedly, he was making a low pass to check for rocks in the stream before landing when a deer jumped up beside the float plane. He stated that he was watching to see…Nov 24, 1983 · N1473C · Substantial damage NTSB NYC83FNC10Accident · Serious injuriesFinal reportPiper PA 28 181 · Baxter State Pk, METhe pilot does not recall any details of the flight after departing montreal. The wreckage was not recovered nor examined.Aug 6, 1983 · CGPJX · Destroyed NTSB NYC82DNC12Accident · No injuriesFinal reportBoeing PT-17 · Hamlin, METhe pilot departed a private strip with 150 gallons of water mixed with fungicide and insecticide. After takeoff, he turned and began climbing over rising terrain. The terrain sloped upward from a river, rising about 400 ft. the pilot reported that he failed…Jul 31, 1982 · N1344M · Substantial damage