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 ERA11CA500Accident · Minor injuriesData collectionFinal reportSpectrum RX 550 · Hartland, MEA total loss of engine power due to fuel contamination.Sep 1, 2011 · UNREG · Substantial damageNTSB ERA11CA517Accident · No injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Stonington, METhe pilot's inadequate landing flare, which resulted in a hard landing during crosswind conditions.Aug 31, 2011 · N90650 · Substantial damageNTSB ERA11LA469Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 180A · Lewiston, METhe separation of the inflation tank gas line due to an improperly positioned valve o-ring. Contributing to the accident was the use of an unapproved inflation tank.Aug 20, 2011 · N75213 · No damageNTSB ERA11LA501Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Monmouth, MEOperation of the airplane by a non-certificated pilot and his failure to maintain airplane control.Aug 18, 2011 · N5048Z · Substantial damageNTSB ERA11CA420Accident · No injuriesData collectionFinal reportDehavilland Tiger Moth DH 82A · Rockland, METhe pilot's failure to maintain a proper approach path during landing.Jul 23, 2011 · N8872 · Substantial damageNTSB ERA11CA410Accident · Minor injuriesData collectionFinal reportSky International A-1C-180 · Fryeburg, METhe pilot's failure to maintain directional control while landing in gusty wind conditions.Jul 20, 2011 · N52LK · Substantial damageNTSB ERA11LA405Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Matinicus Island, METhe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Jul 17, 2011 · N910TA · Substantial damageNTSB ERA11LA336Accident · Serious injuriesLimited investigationFinal reportMarks Ca III Kitfox II · Scarborough, METhe pilot’s failure to maintain control of the airplane while taking off with a gusting wind.Jun 10, 2011 · N915PK · Substantial damageNTSB ERA11FA233Accident · 1 fatalField investigationFinal reportCessna 402B · Biddeford, METhe pilot did not maintain minimum controllable airspeed while on final approach with a partial loss of power in the right engine, which resulted in a loss of control. Contributing to the accident was the partial loss of engine power in the right engine due…Apr 10, 2011 · N402RC · Substantial damageNTSB ERA11CA333Accident · No injuriesData collectionFinal reportCessna 172K · Bar Harbor, METhe pilot's inadequate landing flare while landing with a gusting wind, which resulted in a hard landing.Apr 6, 2011 · N46643 · Substantial damageNTSB ERA11GA207Accident · 1 fatalFinal reportCessna A185F · Ashland, MEAn inadvertent encounter with localized instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.Mar 24, 2011 · N724MT · Substantial damageNTSB ERA11FA182Accident · 1 fatalField investigationFinal reportDiamond DA-40 · Allagash, METhe pilot's inadvertent encounter with icing conditions, which resulted in an aerodynamic stall and loss of control. Contributing was the pilots’ inadequate preflight weather planning.Mar 7, 2011 · CGPDO · Substantial damageNTSB ERA11LA150Accident · Minor injuriesLimited investigationFinal reportFlaglor Tom Kolb Aircraft MK III · Stetson, METhe in-flight failure of the No. 1 composite propeller blade due to fatigue, which resulted in a violent vibration, loss of engine power, and a subsequent forced landing to unsuitable terrain.Feb 17, 2011 · N213 · Substantial damageNTSB ERA11CA134Accident · Serious injuriesData collectionFinal reportPiper PA-12 · Sebago Lake, METhe pilot’s initiation of a right turn with insufficient altitude remaining during an aborted landing resulting in a collision with the landing surface.Feb 5, 2011 · N3806M · Substantial damageNTSB ERA11CA024Accident · Minor injuriesData collectionFinal reportCessna 180 · Summner, METhe pilot's failure to maintain adequate airspeed while on final approach resulting in an aerodynamic stall and a subsequent hard landing.Oct 17, 2010 · N2576K · Substantial damageNTSB ERA10CA469Accident · Serious injuriesData collectionFinal reportCessna 140 · Levant, METhe pilot's failure to obtain adequate airspeed during takeoff, which resulted in an aerodynamic stall.Sep 6, 2010 · N3650V · Substantial damageNTSB ERA10LA453Accident · No injuriesLimited investigationFinal reportCessna 120 · Rockland, METhe loss of engine power for undetermined reasons.Aug 29, 2010 · N2493N · DestroyedNTSB ERA10LA422Accident · 2 fatalLimited investigationFinal reportTaylorcraft BC12-D · Harrison, METhe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Aug 14, 2010 · N96389 · Substantial damageNTSB ERA10LA408Accident · No injuriesLimited investigationFinal reportQuest Kodiak 100 · Naples, MEA loss of control during landing for undetermined reasons.Aug 8, 2010 · N917CM · Substantial damageNTSB ERA10LA390Accident · 1 fatalLimited investigationFinal reportCessna A185F · Rockwood, METhe pilot's failure to retract the landing gear prior to a water landing. Contributing to the accident was the pilot's impairment due to medication.Aug 1, 2010 · N369E · Substantial damageNTSB ERA10CA381Accident · No injuriesData collectionFinal reportCessna 172N · Stonington, METhe pilot's failure to maintain directional control during a crosswind landing.Jul 27, 2010 · N6410F · Substantial damageNTSB ERA10FA364Accident · 2 fatalField investigationFinal reportS.C. Aerostar Yak52 · South Portland, METhe pilot did not maintain adequate airspeed during an emergency return to the airport following a total loss of engine power, which resulted in an inadvertent stall. Contributing to the accident was a total loss of engine power for undetermined reasons and…Jul 17, 2010 · N52MY · Substantial damageNTSB ERA10CA268Accident · No injuriesData collectionFinal reportCessna 172N · Blue Hill, METhe flight instructor’s inability to maintain directional control while landing with gusting winds.May 16, 2010 · N733XD · Substantial damageNTSB ERA10LA105Accident · 1 fatalLimited investigationFinal reportCessna 172S · Greenbush, METhe pilot's improper decision to attempt a transoceanic flight in turbulent, icing conditions, with an overweight airplane that was not approved for moderate turbulence and not equipped with deicing systems. Contributing to the accident was the pilot's…Jan 4, 2010 · N5118J · Substantial damageNTSB ERA10CA068Accident · No injuriesData collectionFinal reportCessna C185F · Auburn, METhe pilot’s failure to maintain directional control while landing.Nov 19, 2009 · N95JR · Substantial damageNTSB ERA10CA010Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Lewiston, METhe loss of tail rotor effectiveness (LTE) resulting from hovering the helicopter in a tailwind.Oct 8, 2009 · N1835E · Substantial damageNTSB ERA09LA457Accident · Serious injuriesLimited investigationFinal reportTidd Wesley Mini-Max · Hodgdon, METhe pilot's mismanagement of the fuel supply, which resulted in fuel starvation.Aug 8, 2009 · N569WT · Substantial damageNTSB ERA09LA436Accident · Minor injuriesLimited investigationFinal reportEurocopter EC130 · Deer Isle, METhe pilot's loss of directional control during an out-of-ground-effect hover.Aug 1, 2009 · M-BOAT · Substantial damageNTSB ERA09LA433Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Livermore Falls, MEA loss of engine power for undetermined reasons.Aug 1, 2009 · N49778 · Substantial damageNTSB ERA09LA438Accident · No injuriesLimited investigationFinal reportChristopher John P CHR-1 · Norridgewock, MEA loss of engine power due to a broken crankshaft for undetermined reasons.Jul 30, 2009 · N179TC · Substantial damageNTSB ERA09CA416Accident · Minor injuriesData collectionFinal reportMaule M7 · Turner, METhe pilot's failure to maintain aircraft control during the landing rollout.Jul 23, 2009 · N595Z · Substantial damageNTSB ERA09CA403Accident · Minor injuriesData collectionFinal reportSmith PA18 replica · Chesterville, METhe pilot's failure to maintain aircraft control while turning from base leg to final approach.Jul 14, 2009 · N846PT · Substantial damageNTSB ERA09LA397Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Auburn, MEA loss of engine power due to fuel contamination. Contributing to the accident was the inadequate maintenance inspection of the airplane and engine's fuel system.Jul 11, 2009 · N2871E · Substantial damageNTSB ERA09CA382Accident · No injuriesData collectionFinal reportCessna 172H · Clifton, METhe pilot's mismanagement of his fuel supply which resulted in fuel starvation and a loss of engine power.Jul 3, 2009 · N1782F · Substantial damageNTSB ERA09LA352Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Islesboro, MEA loss of engine power due to fuel contamination.Jun 15, 2009 · N33243 · Substantial damageNTSB ERA09CA309Accident · No injuriesData collectionFinal reportCessna 172A · Glenburn, METhe pilot's misjudgment of distance and speed during landing.May 26, 2009 · N6843X · Substantial damageNTSB ERA09CA280Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, METhe pilot’s premature rotation during takeoff.Apr 30, 2009 · N739RH · Substantial damageNTSB ERA09CA252Accident · No injuriesData collectionFinal reportCessna/Air Repair 305F · Embden, METhe pilot's failure to obtain the proper touchdown point while landing.Apr 18, 2009 · N60537 · Substantial damageNTSB ERA09CA010Accident · No injuriesData collectionFinal reportCessna 172 · Naples, METhe pilot's failure to maintain directional control of the airplane during takeoff. Contributing to the accident was the wet condition of the grass runway.Oct 3, 2008 · N20921 · Substantial damageNTSB NYC08CA316Accident · No injuriesData collectionFinal reportPiper PA28-140 · Carrabassett, METhe pilot's improper landing flare.Sep 20, 2008 · N2318T · Substantial damageNTSB MIA08CA179Accident · No injuriesData collectionFinal reportCessna 172SP · South Harpswell, METhe pilot's failure to maintain control of the airplane while landing in gusty winds.Sep 1, 2008 · N251SP · Substantial damageNTSB MIA08LA161Accident · 1 fatalLimited investigationFinal reportGT Ultralights Airborne Edge X · Franklin, METhe pilot's improper decision to perform low-altitude maneuvers and his failure to maintain clearance from the surface of the bay. Contributing to the accident was the pilot's impairment due to alcohol.Aug 5, 2008 · UNREG · Substantial damageNTSB NYC08LA223Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Rockland, METhe non-instrument rated pilot becoming spatially disorientated after inadvertently entering instrument flight conditions.Jun 21, 2008 · N8776N · Substantial damageNTSB NYC08FA215Accident · 2 fatalField investigationFinal reportCessna P337H · Cape Elizabeth, METhe pilot's improper decision to continue the flight in instrument meteorological conditions after experiencing an attitude indicator malfunction.Jun 15, 2008 · N15EM · DestroyedNTSB NYC08CA219Accident · Serious injuriesData collectionFinal reportHeldeberg Design Blue Heron Marathon · Avon, METhe pilot's improper decision to takeoff from an area that was not a designated runway, and his failure to maintain clearance of trees.Jun 13, 2008 · N5079W · Substantial damageNTSB NYC08CA192Accident · Minor injuriesData collectionFinal reportPiper PA-32-260 · Millinocket, METhe pilot’s failure to properly monitor fuel consumption during the flight.May 24, 2008 · N4823S · Substantial damageNTSB NYC08FA155Accident · 1 fatalField investigationFinal reportSIAI-Marchetti SF-260 · Belfast, METhe pilot's failure to maintain control of the airplane due to spatial disorientation during an aerobatic maneuver.Apr 6, 2008 · N601RH · Substantial damageNTSB NYC08CA153Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Lincoln, METhe pilot-rated-passenger's failure to maintain directional control during takeoff.Apr 6, 2008 · N2209K · Substantial damageNTSB NYC08CA101Accident · No injuriesData collectionFinal reportCessna 182K · Greenville, METhe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the snow covered runway and sun glare light conditions.Feb 15, 2008 · N3047Q · Substantial damageNTSB MIA08MA051Accident · 2 fatalMajor investigationFinal reportCessna 525 · West Gardiner, METhe pilot's spatial disorientation and subsequent failure to maintain airplane control.Feb 1, 2008 · N102PT · Destroyed