Final NTSB investigations, ME

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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'
    AND c.\"completionStatus\" = 'Completed'
  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 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.Nov 22, 1994 · N19735 · Substantial damageNTSB 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.Oct 23, 1994 · N9667Q · Substantial damageNTSB NYC95LA006Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Farmington, MELoss of engine power for undetermined reasons.Oct 11, 1994 · N2450V · Substantial damageNTSB 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 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.Sep 7, 1994 · N8810Z · Substantial damageNTSB BFO94LA159Accident · No injuriesLimited investigationFinal reportBell UH-1B · Carrabasset, MEFracture failure of the tail rotor drive intermediate gearbox.Aug 31, 1994 · N204JB · Substantial damageNTSB 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.Aug 25, 1994 · N11HK · Substantial damageNTSB 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 · DestroyedNTSB 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 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.Jul 25, 1994 · N32925 · Substantial damageNTSB 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.Jul 12, 1994 · N43579 · Substantial damageNTSB 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.Jul 1, 1994 · N5482K · Substantial damageNTSB 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.Jun 18, 1994 · N2000U · Substantial damageNTSB 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.May 21, 1994 · N3167E · DestroyedNTSB BFO94T#001Accident · No injuriesClass 3Final reportCessna 210 · Augusta, MEApr 20, 1994 · N6428C · Substantial damageNTSB NYC94LA072Accident · Serious injuriesLimited investigationFinal reportRandolph Flagg Boredom Fighter · Norridgewock, METhe loss of engine power for undetermined reasons.Mar 23, 1994 · N1932F · Substantial damageNTSB 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 NYC94LA041Accident · No injuriesLimited investigationFinal reportCessna 172N · Bar Harbor, MEA disconnected fuel line with the carburetor not installed, and improper dispatch of the aircraft.Dec 17, 1993 · N5753E · 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 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.Nov 27, 1993 · N8380J · 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 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…Sep 15, 1993 · N11689 · Substantial damageNTSB BFO93LA166Accident · Minor injuriesLimited investigationFinal reportWilson KIT FOX Model 4 · Bowdoinham, MELoss of engine power for an undetermined reason.Sep 8, 1993 · N193CW · Substantial damageNTSB 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 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 damageNTSB 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.Aug 8, 1993 · N25211 · Substantial damageNTSB NYC93LA146Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Leeds, METhe loss of engine power for undetermined reasons.Aug 7, 1993 · N739EP · Substantial damageNTSB 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.Jul 13, 1993 · N50896 · Substantial damageNTSB BFO93LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Pittsfield, MELoss of the tail wheel steering due to undetermined reason(s).Jul 5, 1993 · N61058 · Substantial damageNTSB 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.Jun 30, 1993 · N3023J · Substantial damageNTSB 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.Jun 24, 1993 · N8557Y · Substantial damageNTSB 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.Apr 6, 1993 · N8775K · 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 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.Mar 19, 1993 · N25881 · Substantial damageNTSB 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.Mar 3, 1993 · N942PS · Substantial damageNTSB 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.Feb 27, 1993 · N4607U · DestroyedNTSB 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.Feb 19, 1993 · N6192A · Substantial damageNTSB 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.Feb 13, 1993 · N403PE · No damageNTSB 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 · DestroyedNTSB BFO92LA138Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Greenville, METhe pilot's inadequate flare resulting in a hard landing.Sep 13, 1992 · N4319A · Substantial damageNTSB BFO92FA127Accident · 1 fatalField investigationFinal reportCessna A150L · Troy, MEFailure of the pilot to maintain proper altitude during an aerobatic manuever.Sep 5, 1992 · N6054J · DestroyedNTSB BFO92LA122Accident · No injuriesLimited investigationFinal reportCessna 185 · Dover Foxcroft, MEInadequate servicing of the aircraft which resulted in the lack of hydraulic fluid and the consequent loss of brake presure.Sep 3, 1992 · N93766 · Substantial damageNTSB NYC92LA180Accident · No injuriesLimited investigationFinal reportPiper PA-46-350 · Sanford, METhe pilot did not follow IFR procedures when he disregarded the decision height limitation and failed to initiate a missed approach which resulted in the airplane striking trees.Aug 28, 1992 · N350PM · Substantial damageNTSB NYC92FA164Accident · Serious injuriesField investigationFinal reportBeech D55 · Oxford, METhe pilot's improper preflight and fuel tank selection for takeoff, which resulted in fuel starvation and loss of power in both engines during takeoff.Aug 14, 1992 · N14WW · Substantial damageNTSB NYC92LA148Accident · Minor injuriesLimited investigationFinal reportBeech 24R · Eliot, METhe pilot allowed the airspeed to get excessive, resulting in the airplane touching down too long and too fast.Aug 8, 1992 · N3824Q · Substantial damageNTSB BFO92LA117Accident · No injuriesLimited investigationFinal reportRobinson R22A · Sanford, METhe pilot's selection of unsuitable terrain to execute a landing.Jul 25, 1992 · N8557Y · 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 BFO92LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Sanford, METhe pilot's inadequate compensation for wind conditions.Jul 5, 1992 · N1607C · Substantial damageNTSB NYC92LA116Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Greenville, METhe pilots decision to initiate a step turn into the wind. Factors related to the accident were the crosswind and gusts.Jun 12, 1992 · N2816K · Substantial damage