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 ERA12CA485Accident · No injuriesData collectionFinal reportBayliss Milton A III X-AIR · Houlton, METhe pilot's failure to maintain directional control during the landing flare in a gusting crosswind, which resulted in a runway excursion.NTSB ERA12LA480Accident · No injuriesLimited investigationFinal reportCessna A185F · Mapleton, METhe pilot’s improper fuel management, which resulted in fuel starvation and a total loss of engine power, and his use of an improper engine restart procedure.NTSB ERA12CA461Accident · No injuriesData collectionFinal reportCzech Sport Piper Sport · Sanford, METhe student pilot’s inadequate landing flare and improper recovery from a bounced landing.NTSB ERA12LA411Accident · 1 fatalLimited investigationFinal reportUniversal Stinson 108 · Portland, MEA fatigue failure of the No. 3 piston skirt, which resulted in a total loss of engine power and the subsequent ditching in the ocean.NTSB ERA12LA397Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Biddeford, MEA total loss of engine power due to water contamination of the fuel. Contributing to the accident was the pilot/owner’s inadequate preflight inspection.NTSB ERA12LA241Accident · No injuriesLimited investigationFinal reportCessna 172K · Belfast, METhe flight instructor’s failure to ensure the radio was set correctly to activate the pilot-controlled lighting, which resulted in poor positioning for a proper landing and a subsequent off-runway forced landing during an attempted go-around. Contributing to…NTSB ERA12LA230Accident · Serious injuriesLimited investigationFinal reportSadler Terry A Merlin · Otisfield, METhe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was his lack of experience in the airplane make and model.NTSB ERA12FA007Accident · 1 fatalField investigationFinal reportCessna 207A · Matinicus Island, METhe pilot’s failure to maintain airplane control during the approach after encountering a gusty crosswind, which resulted in an accelerated stall and uncontrolled descent.NTSB ERA11FA493Accident · 1 fatalField investigationFinal reportCessna 172M · Greenville, METhe pilot's failure to maintain adequate airspeed while manuevering at low altitude, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.NTSB ERA11CA500Accident · Minor injuriesData collectionFinal reportSpectrum RX 550 · Hartland, MEA total loss of engine power due to fuel contamination.NTSB 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.NTSB 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.NTSB 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.NTSB ERA11CA420Accident · No injuriesData collectionFinal reportDehavilland Tiger Moth DH 82A · Rockland, METhe pilot's failure to maintain a proper approach path during landing.NTSB ERA11CA410Accident · Minor injuriesData collectionFinal reportSky International A-1C-180 · Fryeburg, METhe pilot's failure to maintain directional control while landing in gusty wind conditions.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB ERA11GA207Accident · 1 fatalFinal reportCessna A185F · Ashland, MEAn inadvertent encounter with localized instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ERA10CA469Accident · Serious injuriesData collectionFinal reportCessna 140 · Levant, METhe pilot's failure to obtain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB ERA10LA453Accident · No injuriesLimited investigationFinal reportCessna 120 · Rockland, METhe loss of engine power for undetermined reasons.NTSB 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.NTSB ERA10LA408Accident · No injuriesLimited investigationFinal reportQuest Kodiak 100 · Naples, MEA loss of control during landing for undetermined reasons.NTSB 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.NTSB ERA10CA381Accident · No injuriesData collectionFinal reportCessna 172N · Stonington, METhe pilot's failure to maintain directional control during a crosswind landing.NTSB 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…NTSB ERA10CA268Accident · No injuriesData collectionFinal reportCessna 172N · Blue Hill, METhe flight instructor’s inability to maintain directional control while landing with gusting winds.NTSB 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…NTSB ERA10CA068Accident · No injuriesData collectionFinal reportCessna C185F · Auburn, METhe pilot’s failure to maintain directional control while landing.NTSB ERA10CA010Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Lewiston, METhe loss of tail rotor effectiveness (LTE) resulting from hovering the helicopter in a tailwind.NTSB ERA09LA457Accident · Serious injuriesLimited investigationFinal reportTidd Wesley Mini-Max · Hodgdon, METhe pilot's mismanagement of the fuel supply, which resulted in fuel starvation.NTSB ERA09LA436Accident · Minor injuriesLimited investigationFinal reportEurocopter EC130 · Deer Isle, METhe pilot's loss of directional control during an out-of-ground-effect hover.NTSB ERA09LA433Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Livermore Falls, MEA loss of engine power for undetermined reasons.NTSB ERA09LA438Accident · No injuriesLimited investigationFinal reportChristopher John P CHR-1 · Norridgewock, MEA loss of engine power due to a broken crankshaft for undetermined reasons.NTSB ERA09CA416Accident · Minor injuriesData collectionFinal reportMaule M7 · Turner, METhe pilot's failure to maintain aircraft control during the landing rollout.NTSB ERA09CA403Accident · Minor injuriesData collectionFinal reportSmith PA18 replica · Chesterville, METhe pilot's failure to maintain aircraft control while turning from base leg to final approach.NTSB 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.NTSB 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.NTSB ERA09LA352Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Islesboro, MEA loss of engine power due to fuel contamination.NTSB ERA09CA309Accident · No injuriesData collectionFinal reportCessna 172A · Glenburn, METhe pilot's misjudgment of distance and speed during landing.NTSB ERA09CA280Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, METhe pilot’s premature rotation during takeoff.NTSB ERA09CA252Accident · No injuriesData collectionFinal reportCessna/Air Repair 305F · Embden, METhe pilot's failure to obtain the proper touchdown point while landing.NTSB 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.NTSB NYC08CA316Accident · No injuriesData collectionFinal reportPiper PA28-140 · Carrabassett, METhe pilot's improper landing flare.NTSB MIA08CA179Accident · No injuriesData collectionFinal reportCessna 172SP · South Harpswell, METhe pilot's failure to maintain control of the airplane while landing in gusty winds.