NTSB investigations, 1987, 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

19622026
NTSB investigations, 1987, ME per year, 1962–2026: 1,006 cases
19621
196427
196519
196634
196729
196838
196917
197013
197128
197240
197332
197423
197525
197626
197732
197825
197927
198021
198117
198218
198317
198422
198515
198616
198714
198815
198916
199012
199119
199220
199322
199419
199512
199614
19977
199810
199913
200012
200115
200210
200310
200412
20059
200614
20079
200813
200914
201010
201116
201211
20138
20148
20154
20167
20178
20184
201911
20206
20213
20225
20236
20249
20258
20269

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\") = 1987
    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.

NTSB NYC88LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28RT · Houlton, MEDuring a personal transportation flight to quebec city in Canada and while cruising at about 6500 feet, the aircraft experienced an oil pressure light illumination, 43 nautical miles nnw of Houlton VOR on a 306 degree heading. The engine then started to run…Dec 4, 1987 · CGRQU · DestroyedNTSB NYC88LA007Accident · 1 fatalLimited investigationFinal reportPiper J3 · Island Falls, METhe Piper J-3 cub experienced a power loss while cruising at an altitude described by witnesses as just above the trees. The aircraft was destroyed and the pilot was fatally injured. Examination of the engine disclosed that that fuel drain valve on the fuel…Oct 14, 1987 · N92440 · DestroyedNTSB NYC87IA258Incident · Minor injuriesIncident investigationFinal reportBeech 99 · Portland, METhe acft was cruising at 2500 ft with no passengers on board. The co-pilot went into the cabin and noticed a loud hissing noise around the main cabin door. He checked the handle and locking pins and noticed the door was locked. He told the captain who…Sep 2, 1987 · N204BH · No damageNTSB NYC87LA239Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Bingham, METhe plt rprtd he was taking off from a lake & was climbing thru about 200-300 ft AGL when the acft enctrd a severe downdraft. Subsequently, the float plane collided with rising terrain. No preimpact part failure or malfunction was rprtd. The plt rprtd the…Aug 23, 1987 · N96241 · Substantial damageNTSB NYC87LA214Accident · No injuriesLimited investigationFinal reportBeech B19 · Augusta, METhe student plt rprtd that during a practice landing, he rounded out too high. Subsequently, the acft bounced hard & the nose gear collapsed. After coming to rest, the plt exited the acft, but a fire erupted & the acft was destroyed.Aug 4, 1987 · N23838 · DestroyedNTSB NYC87LA205Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Spencer Lake, METhe flight originated at Spencer Lake and flew north then south to baker lake. South of hedgehog mountain the flight encountered downdrafts and a loss of altitude at 500-600 feet per minute. Upon turning right to return to Spencer Lake the aircraft continued…Jul 16, 1987 · N4202M · Substantial damageNTSB NYC87DNC09Accident · No injuriesFinal reportDubois Beta Bird · Biddeford, METhe pilot was practicing takeoffs and landings in his homebuilt aircraft. Directional control of the aircraft was lost after it touched down during a landing. Subsequently, it swerved off the side of the runway, went in an area of tall grass & hit a ditch,…Jul 16, 1987 · N3954D · Substantial damageNTSB NYC87FA204Accident · 4 fatalField investigationFinal reportPiper PA-30 · Lincolnville, METhe plt was making an approach to knox county arpt, rockland me and after receiving a wx report from UNICOM that the local wx was below approach minimums he indicated that he would make a missed approach. There was no further communications from the acft. A…Jul 14, 1987 · N7617Y · DestroyedNTSB NYC87LA197Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Scoodic Lake, METhe plt of the float equipped acft was taking off from Scoodic Lake. Drg the initial climb phase after takeoff, he noted the acft began to lose altitude & would not clear trees on a ridge ahead. He initiated a turn back toward the lake; however, the acft…Jul 5, 1987 · N8955R · Substantial damageNTSB NYC87LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Portland, METhe pilot of the PA-23 was attempting an NDB approach into the Portland, ME. Int'l jetport. The wx was rpt'd as moderate turbulence and moderate or greater icing, the icing level was rpt'd from the surface to 16000 ft. prior to this NDB approach the pilot had…Apr 28, 1987 · N13808 · DestroyedNTSB NYC87DNC05Accident · Minor injuriesFinal reportPiper PA-18-135 · Greenville, METhe pilot was taking off from a lake during windy conditions. The aircraft stalled shortly after takeoff. The aircraft was about 60 feet above the surface. The nose dropped and the aircraft impacted the water. The pilot reported that there was turbulence…Apr 28, 1987 · N114 · DestroyedNTSB NYC87LA130Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Rumford Point, MEWhile circling a pond, the plt failed to switch fuel tanks and the engine lost power. He attempted to switch from the right to the left tank but was forced to set the acft down in a nearby field. The left wing, fuselage, landing gear, prop, and engine mounts…Apr 25, 1987 · N9119K · Substantial damageNTSB NYC87LA168Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Sanford, METhe acft was being hand propped from behind the prop on the rgt side when the eng started. The plane jumped the chock, knocked the plt to the ground, turned to the rgt & collided with a parked acft in the tie-down area. The acft was not tied down & only the…Apr 22, 1987 · N58032 · Substantial damageNTSB NYC87FA120Accident · 4 fatalField investigationFinal reportCessna 172P · Berwick, METhe acft was observed doing stalls. A witness said that prior to the crash he saw the nose lower and the right wing drop. The aircraft then entered into a spiral. It was observed descending into trees in a spiral. The plt was found in the right front seat.…Apr 11, 1987 · N55309 · Destroyed