NTSB investigations, ME

197 cases where the phase of flight was Enroute.

Cases, newest first

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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 case_mkey FROM case_phases WHERE main = 400)
  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 IAD00FA076Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Kennebunkport, MEFracture of the #4 connecting rod for undetermined reasons, which resulted in a loss of engine power. A factor was the forced ocean ditching.Aug 18, 2000 · N411JL · Substantial damageNTSB NYC00MA201Accident · 2 fatalMajor investigationFinal reportGrumman G-159 · Linneus, METhe pilot-in-command's failure to maintain minimum control airspeed, which resulted in a loss of control. Factors in this accident were clouds, and a loss of engine power for undetermined reasons, while in cruise flight above the airplane's single engine…Jul 19, 2000 · CGNAK · DestroyedNTSB NYC99LA144Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-65 · Corinna, METhe pilot-in-command's failure to maintain adequate airspeed which resulted in an inadvertent stall.Jun 17, 1999 · N36205 · Substantial damageNTSB IAD98LA078Accident · Serious injuriesLimited investigationFinal reportMastopietro Rans S12 · Phillips, MELoss of engine power due to a separated oil line. A related factor was the unsuitable field.Jul 9, 1998 · N6191V · Substantial damageNTSB IAD97FA095Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Penobscot, METhe pilot's flight into adverse weather conditions, which resulted in the loss of control. Factors relating to the accident were the fog and the pilot's lack of an instrument rating.Jul 3, 1997 · N3896T · DestroyedNTSB NYC97LA111Accident · No injuriesLimited investigationFinal reportCessna 150K · Jay, MEthe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.Jun 8, 1997 · N6218G · Substantial damageNTSB IAD96LA144Accident · No injuriesLimited investigationFinal reportCessna 150L · Hope, MEinadequate preflight, by not refueling the airplane during an en route stop, which led to fuel exhaustion, loss of engine power, and a subsequent forced landing.Sep 6, 1996 · N6632G · Substantial damageNTSB NYC96LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Castine, MEthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. Factors relating to the accident were: false indication from the fuel quantity gauge, and soft terrain in the emergency…Jul 28, 1996 · N65530 · Substantial damageNTSB NYC96FA123Accident · 2 fatalField investigationFinal reportBeech E90 · Woolwich, MEfailure of the pilot to maintain control of the airplane while climbing after takeoff, due to spatial disorientation, which resulted in an uncontrolled descent and subsequent collision with terrain. Factors relating to the accident were: the improper…Jun 10, 1996 · N916PA · DestroyedNTSB IAD96FA090Accident · 1 fatalField investigationFinal reportCessna 320C · Winslow, MEthe pilot's continued flight into known adverse weather conditions, and his loss of aircraft control, which resulted in an uncontrolled descent into terrain (river). The known icing condition was a related factor.Jun 3, 1996 · N78KA · DestroyedNTSB NYC96LA074Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Shirley, MEthe pilot's fuel mismanagement and improper use of the fuel selector valve which resulted in fuel starvation.Mar 11, 1996 · N712MY · Substantial damageNTSB NYC96LA041Accident · No injuriesLimited investigationFinal reportCessna U206G · Bangor, MEthe pilot's improper inflight planning/decision, and his failure to properly plan his approach for landing, so that the airplane would not stall or touchdown hard. Factors relating to the accident were: the adverse weather (icing) condition, the accumulation…Dec 16, 1995 · N6250X · Substantial damageNTSB NYC96LA017Accident · No injuriesLimited investigationFinal reportCessna 182B · Lebanon, MEthe pilot's improper use of the mixture control which resulted in fuel starvation and loss of engine power.Oct 22, 1995 · N2754G · Substantial damageNTSB NYC95FA188Accident · 1 fatalField investigationFinal reportBeech 58 · Mapleton, METhe pilot inadvertently shut down the right engine and feathered the propeller after a loss of power in the left engine, and he failed to maintain adequate airspeed, which resulted in an inadvertent stall/spin and collision with the ground. A factor relating…Aug 14, 1995 · N168CG · DestroyedNTSB NYC94LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · North Anson, MEthe inadequately installed cylinder mounting stud nuts, by the engine overhaul facility, which resulted in the separation of the number two cylinder and the subsequent forced landing.Sep 10, 1994 · N55GV · Substantial damageNTSB BFO94LA129Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · Bangor, METhe pilot's loss of aircraft control. Factors are dark night conditions, and the pilot's execution of an evasive maneuver.Aug 10, 1994 · N292Q · DestroyedNTSB BFO94LA044Accident · No injuriesLimited investigationFinal reportCessna 172 · East Newport, MEImproper engine maintenance by the operator resulting in oil exhaustion and subsequent internal engine damage.Feb 20, 1994 · N100DF · Substantial damageNTSB NYC94LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · North Haven, METhe pilot's use of excessive speed and altitude during the approach which resulted in a landing overrun of the runway. Factors were a precautionary landing and a ravine.Dec 4, 1993 · N55719 · Substantial damageNTSB BFO94FA013Accident · 3 fatalField investigationFinal reportBell 206L-1 · Portland, METhe pilot's continued VFR flight into instrument meteorological conditions, and his failure to assure that adequate fuel was available to complete the flight, resulting in a loss of engine power due to fuel exhaustion. Factors which contributed to the…Nov 20, 1993 · N911ME · DestroyedNTSB BFO93LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Caribou, MELoss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain.Sep 2, 1993 · N7507P · Substantial damageNTSB NYC93LA171Accident · No injuriesLimited investigationFinal reportCessna 172 · Phillips, METhe pilot's inadequate preflight and inflight decision which resulted in fuel exhaustion and the loss of engine power.Aug 22, 1993 · N90441 · Substantial damageNTSB BFO93LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Monticello, MEA disconnection of the fuel line, which resulted in fuel starvation and loss of engine power. A related factor was the lack of suitable terrain for an emergency landing.Mar 22, 1993 · N41422 · Substantial damageNTSB BFO92FA093Accident · 1 fatalField investigationFinal reportCessna U206F · Portland, MEImproper in-flight planning/decision by the pilot, resulting in fuel starvation due to improper positioning of the fuel selector. Factors related to the accident were: an undetermined electrical failure, and loss of fuel quantity indication.Jul 9, 1992 · CGTCM · Substantial damageNTSB NYC92DNC02Accident · 1 fatalFinal reportCraig Morehead Bushby Mustang II · Buxton, METhe failure of the pilot to maintain airspeed while maneuvering which resulted in an inadvertent stall with insufficent altitude for recovery. Factors related to the accident were the low clouds and fog, and the pilot's failure to obtain a weather briefing.Apr 20, 1992 · N519CS · DestroyedNTSB 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.Nov 24, 1991 · N24894 · Substantial damageNTSB 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…May 23, 1991 · N6968R · Substantial damageNTSB 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.May 12, 1991 · N1745R · Substantial damageNTSB 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.Apr 7, 1991 · N312OU · Substantial damageNTSB NYC91LA096Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bar Harbor, METhe engine lost power for an undetermined reason.Mar 30, 1991 · N2899E · Substantial damageNTSB 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…Mar 23, 1991 · N4155P · Substantial damageNTSB NYC90LA222Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Norridgewock, METhe pilot's improper preflight and inflight planning of the fuel, which resulted in fuel exhaustion and forced landing.Aug 24, 1990 · N250SC · Substantial damageNTSB NYC90LA081Accident · Minor injuriesLimited investigationFinal reportCessna 182-K · Limington, MEFuel starvation, due to carburetor contamination, which resulted in a forced landing in unsuitable terrain.Mar 25, 1990 · N1895Q · DestroyedNTSB NYC90LA021Accident · Minor injuriesLimited investigationFinal reportBoeing B75N · Willimantic, MEAn inadvertent stall clearing trees during a forced landing following a power loss due to a fuel line separating from the carburetor and fuel starvation.Oct 28, 1989 · N68972 · Substantial damageNTSB NYC89FA183Accident · 2 fatalField investigationFinal reportBeech B24R · Wiscasset, METhe pilot's loss of control of the airplane and uncontrolled descent during attempted flight in instrument meteorological conditions.Aug 6, 1989 · N2175W · DestroyedNTSB NYC89LA189Accident · Minor injuriesLimited investigationFinal reportConvair CV-600-240D · Augusta, METhe failure of the propeller control system for undetermined reasons during a precautionary landing after encountering deteriorating weather conditions during a VFR ferry flight. Contributing factor(s) was: the adverse weather conditions, inadequate…Aug 4, 1989 · N94253 · Substantial damageNTSB NYC89LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Walpole, MEA loss of engine power for undetermined reasons. Contributing to the accident was the powerline which the airplane contacted.Jul 13, 1989 · N5014H · Substantial damageNTSB NYC89LA078Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Kennebunk, METhe pilot's failure to assure the fuel selector was properly positioned which resulted in fuel starvation and the subsequent forced landing.Feb 1, 1989 · N67561 · Substantial damageNTSB 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…Dec 17, 1988 · N6558P · DestroyedNTSB 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…May 23, 1988 · N46413 · Substantial damageNTSB 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 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 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 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…Oct 13, 1986 · N5255R · Substantial damageNTSB 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…Jun 9, 1986 · N8384Q · Substantial damageNTSB 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…Apr 15, 1986 · N6264W · Substantial damageNTSB 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…Apr 2, 1986 · N5082H · Substantial damageNTSB 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…Mar 22, 1986 · N4211T · Substantial damage