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 MIA08CA037Accident · No injuriesData collectionFinal reportCessna 170A · Ellsworth, METhe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's selection of an unsuitable landing area.Jan 6, 2008 · N5407C · Substantial damageNTSB NYC08CA017Accident · No injuriesData collectionFinal reportCessna 152 · Greenville, METhe pilot's failure to maintain adequate clearance from trees during the approach.Oct 20, 2007 · N757DP · Substantial damageNTSB DFW08LA019Accident · No injuriesLimited investigationFinal reportCessna U206G · Lebanon, MEFailure of the crankshaft resulting in the total loss of engine power.Oct 18, 2007 · N8777Q · Substantial damageNTSB ANC08LA007Accident · No injuriesLimited investigationFinal reportCessna 172M · Rangeley, METhe pilot's failure to maintain aircraft control during the landing flare/touchdown. A factor contributing to the accident was the pilot's diverted attention.Oct 18, 2007 · N92737 · Substantial damageNTSB ATL07LA110Accident · 1 fatalLimited investigationFinal reportCessna T206H · Lovell, METhe pilot's failure to retract the amphibious floatplane's landing gear during a water landing.Aug 4, 2007 · N206MW · Substantial damageNTSB MIA07LA124Accident · Minor injuriesLimited investigationFinal reportDennis M. Durgin Junior Ace · Dover-Foxcroft, METhe failure of the pilot to maintain airspeed following total loss of engine power due to fuel starvation, resulting in a stall/mush, uncontrolled descent, and in-flight collision with trees.Jul 21, 2007 · N9778N · Substantial damageNTSB NYC07CA163Accident · Minor injuriesData collectionFinal reportCessna 182K · Matincus Island, MEAn evasive maneuver to avoid a bird, while on final approach, which resulted in an in-flight collision with trees.Jul 8, 2007 · N2762Q · Substantial damageNTSB NYC07CA150Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Machias, METhe pilot's inadequate in-flight planning.Jun 26, 2007 · N5457P · Substantial damageNTSB MIA07CA095Accident · Minor injuriesData collectionFinal reportCessna 172-M · Oxford, METhe student pilot's failure to maintain a climb during a go-around resulting in collision with an embankment.May 8, 2007 · N80132 · Substantial damageNTSB NYC07CA097Accident · No injuriesData collectionFinal reportCessna A185F · Ashland, METhe pilot's failure to maintain aircraft control while taxiing, which resulted in a nose over. A factor in this accident was the frozen, slush covered lake.Apr 14, 2007 · N4756E · Substantial damageNTSB NYC07LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Livermore Falls, METhe pilot's failure to maintain directional control during landing, which resulted in a groundloop.Dec 3, 2006 · N8019F · Substantial damageNTSB NYC06LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Orient, METhe pilot's failure to maintain adequate airspeed during the initial climb which resulted in an inadvertent stall. A factor was his inadequate weight and balance calculations and the gusty wind conditions.Sep 22, 2006 · N4459M · DestroyedNTSB NYC06IA226Incident · No injuriesIncident investigationFinal reportCessna 206F · Matinicus Islnd, MEAn engine kick back of undetermined origin during engine start.Sep 1, 2006 · N8411Q · Minor damageNTSB NYC06LA157Accident · Serious injuriesLimited investigationFinal reportWorcester Everett Renegade II · Orneville, MEA loss of engine power for an undetermined reason.Jun 24, 2006 · N536N · DestroyedNTSB NYC06FA154Accident · 4 fatalField investigationFinal reportCessna 172N · Newry, METhe flight instructor's failure to maintain altitude/clearance while maneuvering, which resulted in an impact with trees.Jun 22, 2006 · N572BA · DestroyedNTSB NYC06CA146Accident · Serious injuriesData collectionFinal reportTheordore Jankowski Rans S-12 · Caribou, METhe pilot's failure to maintain directional control which resulted in a subsequent impact with trees. A factor in the accident was the unmowed area of vegetation.Jun 14, 2006 · N248PC · Substantial damageNTSB NYC06CA140Accident · No injuriesData collectionFinal reportCessna A185E · Turner, METhe pilot's failure to obtain the proper touchdown point, resulting in a runway undershoot, and substantial damage to the airplane.Jun 6, 2006 · N185RW · Substantial damageNTSB NYC06CA126Accident · No injuriesData collectionFinal reportPiper J3C · Old Town, METhe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with water.May 29, 2006 · N1401V · Substantial damageNTSB NYC06CA125Accident · No injuriesData collectionFinal reportRobinson R-22 · Sanford, METhe flight instructor's inadvertent encounter with settling-with-power, which resulted in a hard landing, and subsequent roll-over. A factor in the accident was the tailwind.May 28, 2006 · N720RJ · Substantial damageNTSB NYC06LA091Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Passadumkeag, METhe partially blocked fuel line, which resulted in fuel starvation and a subsequent loss of engine power. Factors in the accident included inadequate maintenance, and the unsuitable terrain.Apr 10, 2006 · N714EJ · Substantial damageNTSB NYC06CA084Accident · No injuriesData collectionFinal reportCessna 180F · Greenville, METhe pilot's failure to maintain directional control during landing, resulting in a ground loop. A factor was the rough/uneven runway condition.Mar 25, 2006 · N2165Z · Substantial damageNTSB NYC06LA070Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Dover-Foxcroft, METhe pilot's inadequate preflight inspection, which failed to detect ice in the fuel system, resulting in a loss of engine power during takeoff-initial climb, and an in-flight collision with trees.Feb 18, 2006 · N7694E · Substantial damageNTSB NYC06CA069Accident · No injuriesData collectionFinal reportCessna 152 · Augusta, METhe pilot's improper flare, which resulted in a hard landing.Feb 15, 2006 · N47105 · Substantial damageNTSB NYC06CA060Accident · No injuriesData collectionFinal reportCessna 305A · Seboeis, METhe pilot's failure to maintain clearance from power lines, while attempting to land on a frozen lake.Jan 20, 2006 · N5300G · Substantial damageNTSB NYC05LA142Accident · No injuriesLimited investigationFinal reportRaytheon BE-390 · Rockland, METhe pilot's failure to maintain aircraft control during landing.Sep 15, 2005 · N701DF · Substantial damageNTSB IAD05LA138Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Rangeley, MEA malfunction of the yaw damper system due to fluid contamination. Factors in the accident were the air condition exhaust vent design and the design stress limits of the airplane were exceeded.Sep 12, 2005 · N747AW · Substantial damageNTSB IAD05CA134Accident · Serious injuriesData collectionFinal reportLamont Aventura II · Hope, METhe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin and subsequent impact with water. A factor to the accident was the wind gusts.Sep 10, 2005 · N9138W · Substantial damageNTSB NYC05FA138Accident · 1 fatalField investigationFinal reportCessna 172C · Winthrop, METhe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion, and a subsequent forced landing and impact with terrain.Aug 27, 2005 · N1680Y · Substantial damageNTSB IAD05CA128Accident · No injuriesData collectionFinal reportPresley RV-4 · Biddeford, METhe pilot's failure to maintain directional control. Contributing to the accident was the wind gusts.Aug 27, 2005 · N228X · Substantial damageNTSB IAD05CA117Accident · Minor injuriesData collectionFinal reportCessna C-172G · Eustis, METhe pilot's failure to maintain clearance from a bush during the aborted landing.Aug 5, 2005 · N5924R · Substantial damageNTSB NYC05IA128Incident · No injuriesIncident investigationFinal reportBeech 1900D · Rockland, MEA loose elevator attachment, which resulted in a partial elevator binding during takeoff and uncommanded elevator movement during cruise.Aug 2, 2005 · N136MJ · No damageNTSB NYC05CA077Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Portland, MEA loss of engine power due to the pilot's improper decision not to land and refuel resulting in fuel exhaustion.May 6, 2005 · N238PP · Substantial damageNTSB NYC05CA078Accident · No injuriesData collectionFinal reportCessna 150F · China, METhe pilot's improper inflight decision to land in a field instead of a nearby airport, after encountering deteriorating weather conditions. A factor was the deteriorating weather conditions.Apr 30, 2005 · N6256R · Substantial damageNTSB IAD05IA004Incident · Minor injuriesIncident investigationFinal reportRaven Industries S-60A · Auburn, METhe pilot's maneuver into a tree, which resulted in an inadvertent contact between a branch and a passenger.Oct 14, 2004 · C-GGAX · No damageNTSB NYC05CA003Accident · No injuriesData collectionFinal reportCessna 172M · Eliot, METhe pilot's inadequate in-flight planning decision, which resulted a loss of engine power due to fuel exhaustion.Oct 9, 2004 · N80657 · Substantial damageNTSB NYC04LA210Accident · No injuriesLimited investigationFinal reportCessna 172B · Wiscasset, METhe failure of the oil filter adapter seal, which resulted in a loss of oil pressure, and subsequent catastrophic engine failure, and forced landing.Sep 12, 2004 · N7422X · Substantial damageNTSB IAD04CA038Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Eliot, METhe pilot's failure to maintain airspeed above stall which resulted in a hard landing and collapse of the landing gear. Also causal was the flight instructor's inadequate supervision.Aug 17, 2004 · N4631J · Substantial damageNTSB IAD04LA036Accident · 1 fatalLimited investigationFinal reportCessna 172M · Brownville Junc, METhe pilot's continued visual flight into instrument meteorological conditions, which resulted in the airplane's controlled flight into rising terrain. Factors included the instrument meteorological conditions and the rising terrain.Aug 12, 2004 · N12959 · Substantial damageNTSB NYC04CA190Accident · Serious injuriesData collectionFinal reportClassic Waco YMF · Bar Harbor, METhe pilot's inadequate compensation for wind conditions. A factor was the crosswind.Aug 9, 2004 · N723SR · Substantial damageNTSB IAD04IA032Incident · No injuriesIncident investigationFinal reportAviat A-1A · Fryeburg, METhe pilot's improper use of carburetor heat, which resulted in a loss of engine power. A factor was the lack of suitable terrain for the forced landing.Jul 16, 2004 · N4674L · Minor damageNTSB IAD04LA029Accident · No injuriesLimited investigationFinal reportCessna 421B · Portland, MEFailure of the right main landing gear down-lock mechanism resulting in the collapse of the right main landing gear.Jul 2, 2004 · N421KS · Substantial damageNTSB 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.May 17, 2004 · N7793E · Substantial damageNTSB 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.May 13, 2004 · N59MH · Substantial damageNTSB 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.Mar 14, 2004 · N7872G · Substantial damageNTSB NYC04LA060Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Sanford, MEAn engine fire for undetermined reasons during start-up.Jan 25, 2004 · N6234M · DestroyedNTSB 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.Nov 5, 2003 · N805TH · Minor damageNTSB 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.Sep 14, 2003 · N10224 · Substantial damageNTSB 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.Sep 14, 2003 · N755FA · Substantial damageNTSB 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.Sep 7, 2003 · N6445X · Substantial damageNTSB 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.Aug 31, 2003 · N11576 · Substantial damage