NTSB investigations, 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, newest first
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 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 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 NYC95FA210Accident · 3 fatalField investigationFinal reportCessna 172M · Portland, MEan engine malfunction for an undetermined reason, and the pilot's failure to maintain airspeed during a forced landing which resulted in an accelerated stall. A factor was the pilot's lack of recent experience.NTSB NYC95LA198Accident · Minor injuriesLimited investigationFinal reportBell 206B · Bingham, MEthe pilot's inadequate landing flare resulting in a hard landing and roll over, and a subsequent collision with trees.NTSB 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…NTSB BFO95LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Phillips, MEthe private pilot's failure to obtain/maintain altitude/clearance from obstacles during the takeoff/initial climb. Related factors are the grass/turf runway, the improper weight and balance, and the tailwind.NTSB NYC95LA094Accident · No injuriesLimited investigationFinal reportCessna 172G · Augusta, METhe student pilot's delay in aborting the landing attempt. The crosswind, and the pilot's inadequate compensation for the crosswind were factors.NTSB NYC95LA093Accident · No injuriesLimited investigationFinal reportCessna 185 · Bangor, MEthe pilot's improper flare, which resulted in a hard landing and collapse of the right main gear.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.NTSB NYC95LA036Accident · No injuriesLimited investigationFinal reportPiper J3C · Waldoboro, METhe pilot's premature lift off which resulted in insufficient climb performance and collision with trees.NTSB NYC95LA037Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glenburn, METhe pilot's (1) improper decision to initiate a takeoff with ice on the wing.NTSB BFO95LA014Accident · No injuriesLimited investigationFinal reportCessna 172L · Bethel, MEthe flight instructor's failure to ensure adequate control of the airplane during a go-around. The gusty wind conditions were contributing factors.NTSB BFO95LA007Accident · No injuriesLimited investigationFinal reportCessna A185F · N New Portland, METhe pilot's failure to verify the landing gear was in the proper position for landing.NTSB NYC95LA006Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Farmington, MELoss of engine power for undetermined reasons.NTSB 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.NTSB NYC94LA170Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Houlton, MEInadequate maintenance inspection which failed to detect internal corrosion of the magneto, resulting in ignition arcing and the loss of engine power.NTSB BFO94LA159Accident · No injuriesLimited investigationFinal reportBell UH-1B · Carrabasset, MEFracture failure of the tail rotor drive intermediate gearbox.NTSB BFO94LA148Accident · No injuriesLimited investigationFinal reportPiper PA -28-181 · Skowhegan, METhe pilot's failure to do a go around which resulted in an inflight collision with trees during a delayed aborted landing to avoid a runway overrun.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.NTSB 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.NTSB NYC94LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Augusta, METhe improper positioning of the fuel selector because of inadequate inflight decision/planning which resulted in fuel exhaustion and the loss of engine power.NTSB NYC94LA120Accident · No injuriesLimited investigationFinal reportFreeman PRO-STAR II · Sanford, METhe pilot's failure to maintain airspeed resulting in an inadvertent stall and collision with the terrain.NTSB NYC94LA104Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Greenville, METhe premature retraction of the wing flaps by the pilot after takeoff, resulting in a loss of lift and collision with trees.NTSB BFO94LA115Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Orrington, METhe pilot misjudged his altitude and airspeed which resulted in a hard landing. Related factors were the soft, and upslope field.NTSB NYC94LA088Accident · 1 fatalLimited investigationFinal reportAeronca 11AC · Berwick, METhe pilot's inadequate preflight which fail to detect proper operation of the elevator which resulted in the loss of control inflight. A factor is inadequate maintenance which consisted of misrigging of the elevator flight controls.NTSB BFO94T#001Accident · No injuriesClass 3Final reportCessna 210 · Augusta, MENTSB NYC94LA072Accident · Serious injuriesLimited investigationFinal reportRandolph Flagg Boredom Fighter · Norridgewock, METhe loss of engine power for undetermined reasons.NTSB BFO94LA044Accident · No injuriesLimited investigationFinal reportCessna 172 · East Newport, MEImproper engine maintenance by the operator resulting in oil exhaustion and subsequent internal engine damage.NTSB NYC94LA041Accident · No injuriesLimited investigationFinal reportCessna 172N · Bar Harbor, MEA disconnected fuel line with the carburetor not installed, and improper dispatch of the aircraft.NTSB 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.NTSB BFO94LA020Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Rockland, ME1) The pilot's failure to maintain adequate rotor RPM, 2) the pilot's failure to maintain directional control on landing, resulting in a dynamic rollover.NTSB 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…NTSB BFO93LA177Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Mattawamkeag, ME1) The pilot's initiation of an excessive maneuver (steep bank turn) at 400 feet above the ground, which resulted in an aerodynamic stall, and 2) the pilot's lack of recognition of the nature of the emergency, causing a delay in performing remedial action to…NTSB BFO93LA166Accident · Minor injuriesLimited investigationFinal reportWilson KIT FOX Model 4 · Bowdoinham, MELoss of engine power for an undetermined reason.NTSB BFO93LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Caribou, MELoss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain.NTSB 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.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.NTSB NYC93LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Fryeburg, METhe student pilot's improper recovery from a bounced landing resulting in the collapse of the nose gear and the subsequent nose over. A factor was an improper flare.NTSB NYC93LA146Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Leeds, METhe loss of engine power for undetermined reasons.NTSB BFO93LA120Accident · Minor injuriesLimited investigationFinal reportCessna 150J · East Corinth, METhe pilot's misjudgement of airspeed while making a precautionary landing without airspeed indication, and the block pitot tube.NTSB BFO93LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Pittsfield, MELoss of the tail wheel steering due to undetermined reason(s).NTSB NYC93LA134Accident · No injuriesLimited investigationFinal reportCessna 150E · Oxford, METhe pilot's improper landing flare which resulted in a hard landing. A factor was the pilot's lack of experience.NTSB NYC93LA126Accident · No injuriesLimited investigationFinal reportRobinson R22 · Sanford, METhe pilot's failure to maintain directional control of the helicopter while hovering, resulting in the main rotor blades impacting the ground.NTSB NYC93LA070Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Norridgewock, METhe pilot at the controls failed to maintain directional control of the airplane, and the flight instructor provided inadequate supervision. A related factor was the pilot at the controls had no flight experience in the make and model of airplane being flown.NTSB 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.NTSB BFO93LA052Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · New Gloucester, MELoss of engine power during takeoff due to undetermined reasons, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB BFO93LA042Accident · Minor injuriesLimited investigationFinal reportAsselyn Xenair CH701 · Durham, METhe pilot's inadequate compensation for wind conditions and failure to maintain directional control after lift-off. Factors related to the accident were: the unfavorable wind condition and proximity of the power line.NTSB BFO93FA034Accident · 1 fatalField investigationFinal reportCessna 180F · Brewer, MELoss of engine power due to undetermined reasons, and the failure of the pilot to maintain adequate airspeed during the forced landing which resulted in a stall.NTSB BFO93LA028Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Pittsfield, METhe pilot's inadequate inflight decision to continue a landing without runway lights, and his delay in initiating a go-around. A related factor was the pilot's over confidence in his ability.NTSB BFO93IA026Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Portland, METhe pilot in command's excessive airspeed during approach, and his failure to follow the proper braking procedures during landing as per company training. Factors contributing to the accident include a tailwind and a wet, downhill runway.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.NTSB BFO92LA138Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Greenville, METhe pilot's inadequate flare resulting in a hard landing.