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 IAD04LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Old Town, METhe pilot's failure to abort the takeoff. Factors were the pilot's incorrect assessment of the airplane's weight and the muddy terrain.NTSB NYC04LA122Accident · No injuriesLimited investigationFinal reportGarlick Helicipters OH-58A · Columbia, MEA partial loss of engine power for undetermined reasons, which resulted in a forced landing during cruise flight.NTSB NYC04LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Turner, METhe pilot's misjudgment of speed/distance and the delayed aborted landing. A factor in this accident was the tail wind condition.NTSB NYC04LA060Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Sanford, MEAn engine fire for undetermined reasons during start-up.NTSB NYC04IA023Incident · No injuriesIncident investigationFinal reportCessna 208B · Bangor, METhe pilot's inability to see through the windshield, which was obscured due to icing conditions. This resulted in the pilot's inadequate flare, and a subsequent hard landing. A factor contributing to the accident was the wing icing.NTSB NYC03LA210Accident · No injuriesLimited investigationFinal reportSimoneau Kitfox Classic IV · Limington, METhe pilot's improper flare, which resulted in a hard landing. A factor in this accident was the pilot's lack of experience in make and model.NTSB NYC03FA197Accident · 3 fatalField investigationFinal reportCessna U206F · Greenville, METhe pilot's improper fuel management by which he failed to position the fuel selector in the proper position and resulted in fuel starvation during the initial climb.NTSB NYC03LA196Accident · Minor injuriesLimited investigationFinal reportCessna 180D · Greenville, METhe inadequate installation and inspection of an aileron cable by maintenance personnel, which resulted in a loss of control in-flight and subsequent collision with water.NTSB IAD03CA072Accident · No injuriesData collectionFinal reportCessna C-170 · Kennebunkport, METhe pilot's failure to obtain the proper touchdown point, which resulted in the abrupt maneuver and subsequent failure of the landing gear.NTSB NYC03LA178Accident · No injuriesLimited investigationFinal reportAerofab Lake 250 · Phippsburg, METhe airplane's collision with a submerged object during a water landing.NTSB 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…NTSB 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.NTSB 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.NTSB NYC03LA044Accident · Serious injuriesLimited investigationFinal reportLuscombe 8F · Newport, METhe fatigue failure of a the cylinder wall.NTSB NYC03LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Turner, METhe pilot's misjudgment of distance which resulted in an overrun.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB NYC02LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Sangerville, METhe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB IAD01LA104Accident · No injuriesLimited investigationFinal reportCessna 172P · Augusta, METhe pilot's failure to maintain the proper distance from a sign post during taxi.NTSB IAD01LA105Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, METhe student pilot's improper flare, which resulted in a hard landing.NTSB NYC01FA201Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Sedgwick, METhe failure of the pilot to maintain control while maneuvering.NTSB 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.NTSB 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.NTSB NYC01LA149Accident · No injuriesLimited investigationFinal reportCessna 150 · Lincoln, MEA loss of engine power for an undetermined reason.NTSB IAD01LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ashland, MEloss of partial engine power due to carburetor icing.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB NYC01LA027Accident · No injuriesLimited investigationFinal reportO Loughlin WAG-A-BOND · Greenville, METotal loss of engine power for undetermined reasons.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB IAD00LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Norridgewock, MEthe student pilot's loss of directional control during the takeoff roll.NTSB NYC00LA070Accident · No injuriesLimited investigationFinal reportCessna 150 · Wiscasset, METhe pilot's inadequate preflight inspection.