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 NYC03LA178Accident · No injuriesLimited investigationFinal reportAerofab Lake 250 · Phippsburg, METhe airplane's collision with a submerged object during a water landing.Aug 17, 2003 · N8550U · Substantial damageNTSB NYC03FA129Accident · 2 fatalField investigationFinal reportCessna 150H · Pittsfield, METhe inadvertent resumption of power during a forced landing that resulted in a subsequent spin. Factors related to the accident were the CFI's delayed remedial action, the loss of engine power due to contaminated fuel, an obstructed fuel screen, and the…Jun 12, 2003 · N6566S · DestroyedNTSB NYC03GA094Accident · 1 fatalFinal reportPiper PA-18-150 · Ashland, METhe pilot's impairment due to over-the-counter medications, which resulted in a loss of aircraft control while maneuvering.May 4, 2003 · N46773 · Substantial damageNTSB NYC03LA055Accident · No injuriesLimited investigationFinal reportCessna 140 · Fryeburg, MEAn in-flight encounter with carburetor ice, which resulted in a total loss of engine power during a simulated engine failure.Feb 16, 2003 · N76897 · Substantial damageNTSB NYC03LA044Accident · Serious injuriesLimited investigationFinal reportLuscombe 8F · Newport, METhe fatigue failure of a the cylinder wall.Jan 26, 2003 · N1484B · Substantial damageNTSB NYC03LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Turner, METhe pilot's misjudgment of distance which resulted in an overrun.Nov 9, 2002 · N223T · Substantial damageNTSB IAD03LA009Accident · No injuriesLimited investigationFinal reportCessna 185 · Waterville, METhe pilot's excessive braking during the landing roll, which resulted in a nose over. A factor was the quartering tailwind.Oct 22, 2002 · N7321H · Substantial damageNTSB 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 · DestroyedNTSB NYC03FA002Accident · Serious injuriesField investigationFinal reportCessna 525A · Dexter, MEwas the pilot's improper decision to land with excessive speed, and his delayed decision to perform an aborted landing, both of which resulted in a runway overrun. A factor was the tail wind.Oct 7, 2002 · N57EJ · Substantial damageNTSB NYC02LA195Accident · 1 fatalLimited investigationFinal reportPaiement Rans S-12 · Mercer, METhe pilot's improper in-flight decision, and failure to maintain adequate clearance, which resulted in a collision with a wire during a low altitude flight.Sep 24, 2002 · N7011Y · Substantial damageNTSB NYC02LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Sangerville, METhe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall.Aug 14, 2002 · N56BC · Substantial damageNTSB IAD02LA073Accident · No injuriesLimited investigationFinal reportPiper PA-11S · Palermo, MEpilot's failure to maintain directional control and his inadequate compensation for wind. A factor was the crosswind.Jul 16, 2002 · N4504M · Substantial damageNTSB NYC02LA120Accident · Serious injuriesLimited investigationFinal reportSmith Kitfox Classic IV · Limerick, METhe pilot's failure to perform a modification required by the manufacturer, which resulted in a failure of the float covering.Jun 20, 2002 · N3023J · Substantial damageNTSB IAD02LA041Accident · No injuriesLimited investigationFinal reportCessna U206F · Matinicus, MEA partially blocked fuel metering unit inlet screen, which resulted in a partial loss of engine power. Also causal, was the operator's lack of inlet screen inspection procedures.Apr 3, 2002 · N1523U · Substantial damageNTSB IAD02LA027Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Waterville, METhe pilot's improper decision to attempt a takeoff from a snow-covered runway with a quartering tailwind.Jan 25, 2002 · N8RQ · Substantial damageNTSB IAD02LA021Accident · No injuriesLimited investigationFinal reportCessna 208B · Lewiston, METhe pilot's failure to adequately ensure the wings were free of contamination prior to departure. Factors included the operator's inadequate de-icing procedures and the snowy weather conditions.Dec 21, 2001 · N207TA · Substantial damageNTSB IAD02LA019Accident · Minor injuriesLimited investigationFinal reportPiper J3 · Livermore Falls, METhe pilot's failure to maintain proper altitude clearance while landing, which resulted in a collision with trees. A factor was the crosswind.Dec 7, 2001 · N40621 · Substantial damageNTSB NYC02LA023Accident · No injuriesLimited investigationFinal reportBeech 1900C · Bar Harbor, MEA deer, which had been crossing the runway as the airplane touched down. A factor was the dark night conditions.Nov 2, 2001 · N210CJ · Substantial damageNTSB IAD02LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Phillips, MELoss of engine power due to a blockage of the left fuel tank vent line with mud, and the subsequent inadvertent stall.Oct 4, 2001 · N7591X · Substantial damageNTSB NYC02LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Ashland, METhe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.Oct 2, 2001 · N2528M · Substantial damageNTSB IAD01LA104Accident · No injuriesLimited investigationFinal reportCessna 172P · Augusta, METhe pilot's failure to maintain the proper distance from a sign post during taxi.Sep 2, 2001 · N65057 · Substantial damageNTSB IAD01LA105Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, METhe student pilot's improper flare, which resulted in a hard landing.Aug 25, 2001 · N2009A · Substantial damageNTSB NYC01FA201Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Sedgwick, METhe failure of the pilot to maintain control while maneuvering.Aug 5, 2001 · N80195 · DestroyedNTSB NYC01LA184Accident · No injuriesLimited investigationFinal reportPohl Lancair IV-P · Fryeburg, MEA partial blockage of the air intake system, due to the pilot's failure to ensure the engine compartment was clear of paper towels after a maintenance inspection.Jul 23, 2001 · N488SD · Substantial damageNTSB NYC01LA183Accident · No injuriesLimited investigationFinal reportBeech BE-36 · Biddeford, METhe pilot's inadequate preflight inspection, which resulted in an attempted takeoff with a control column lock installed.Jul 22, 2001 · N3680U · Substantial damageNTSB NYC01LA149Accident · No injuriesLimited investigationFinal reportCessna 150 · Lincoln, MEA loss of engine power for an undetermined reason.Jun 14, 2001 · N1525Q · Substantial damageNTSB IAD01LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ashland, MEloss of partial engine power due to carburetor icing.May 12, 2001 · N1674E · Substantial damageNTSB NYC01LA119Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Monson, METhe pilot's inadequate aircraft preflight inspection, which resulted in a total loss of engine power during climb due to fuel contamination.May 10, 2001 · N4737E · Substantial damageNTSB NYC01LA118Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Brewer, METhe pilot's inadequate preflight preparation, which resulted in insufficient fuel in the forward tank and loss of engine power during the climb. Also causal, was the pilot's failure to maintain airspeed after the engine failure, which resulted in an…May 6, 2001 · N9267E · Substantial damageNTSB IAD01LA030Accident · No injuriesLimited investigationFinal reportCessna 120 · Trenton, METhe pilot's improper touchdown in the snow after the airplane became prematurely airborne during an attempted takeoff. A factor was the pilot's inadequate training.Jan 25, 2001 · N3070N · Substantial damageNTSB 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 · DestroyedNTSB NYC01LA027Accident · No injuriesLimited investigationFinal reportO Loughlin WAG-A-BOND · Greenville, METotal loss of engine power for undetermined reasons.Oct 27, 2000 · N51AT · Substantial damageNTSB 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 damageNTSB 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 NYC00LA191Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · Harpswell, METhe pilot-in-command's improper in-flight decision to maneuver at a low airspeed with a left-quartering tailwind which resulted in a loss of tailrotor effectiveness.Jul 11, 2000 · N2365S · Substantial damageNTSB NYC00LA193Accident · No injuriesLimited investigationFinal reportCessna U206G · North Haven, METhe pilot's failure to perform a go-around. Factors related to the accident were the pilot's lack of total flight experience in make and model, and the short landing area.Jul 6, 2000 · N756HK · Substantial damageNTSB NYC00LA168Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Turner, METhe pilot's failure to maintain directional control after landing. A factor in this accident was the high grass along the runway edge which disguised an embankment.Jun 17, 2000 · N2063N · Substantial damageNTSB NYC00LA143Accident · No injuriesLimited investigationFinal reportde Havilland DH-82A · Pittsfield, METhe pilot's improper use of unsuitable terrain for landing. A factor in the accident was the soft terrain.May 26, 2000 · N8872 · Substantial damageNTSB IAD00LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Norridgewock, MEthe student pilot's loss of directional control during the takeoff roll.Feb 13, 2000 · N5679R · Substantial damageNTSB NYC00LA070Accident · No injuriesLimited investigationFinal reportCessna 150 · Wiscasset, METhe pilot's inadequate preflight inspection.Jan 29, 2000 · N7854E · Substantial damageNTSB NYC00LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Harpswell, MEwas the improper decision of the pilot to depart at night, from an unlighted runway with no visual references to obstructions on the sides of the runway. Factors were the dark night conditions, and the lack of runway side lights.Jan 9, 2000 · N8463X · Substantial damageNTSB NYC00LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Wales, MEFuel exhaustion due to a blocked fuel feed line.Dec 12, 1999 · N5279Z · Substantial damageNTSB 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 damageNTSB NYC00LA011Accident · No injuriesLimited investigationFinal reportCessna 172I · N. East Carry, METhe pilot's decision to attempt a takeoff under gusty wind and rough water conditions.Oct 9, 1999 · N35669 · Substantial damageNTSB NYC00LA003Accident · No injuriesLimited investigationFinal reportPiper PA-60-700P · Greenville, METhe pilot's inadequate preflight planning and his inadequate visual lookout.Oct 3, 1999 · N407SA · Substantial damageNTSB 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 damageNTSB NYC99LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, MEImproper recovery from a bounced landing.Sep 13, 1999 · N5337L · Substantial damageNTSB NYC99LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Greenville, METhe pilot in command's inattentive management of the fuel supply.Sep 2, 1999 · N2584P · Substantial damageNTSB NYC99FA210Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Saddle Island, METhe pilot's failure to maintain altitude/clearance from trees.Aug 24, 1999 · N98PK · Substantial damage