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 NYC99LA176Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Sanford, METhe pilot's failure to maintain control of the airplaneJul 15, 1999 · N404EC · Substantial damageNTSB NYC99LA144Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-65 · Corinna, METhe pilot-in-command's failure to maintain adequate airspeed which resulted in an inadvertent stall.Jun 17, 1999 · N36205 · Substantial damageNTSB NYC99LA149Accident · No injuriesLimited investigationFinal reportCessna 172L · Millinocket, METhe total loss of engine power for undetermined reasons.Jun 16, 1999 · N7897G · Substantial damageNTSB IAD99LA031Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Sanford, METhe pilot mismanaged his fuel supply which led to fuel starvation and subsequent loss of engine power.Feb 27, 1999 · N4524Y · Substantial damageNTSB IAD99LA073Accident · No injuriesLimited investigationFinal reportMonocoupe 110 · Limington, MEPilot's failure to maintain directional control during the landing rollout.Feb 14, 1999 · N10730 · Substantial damageNTSB NYC98LA176Accident · No injuriesLimited investigationFinal reportCessna 182Q · Bingham, METhe pilot's inattention to changing wind conditions, and lack of correction for the change. A factor in the accident was the damp grass runway.Aug 28, 1998 · N735PS · Substantial damageNTSB IAD98LA083Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Newburg, METhe pilot's failure to maintain directional control. Related factors were the long, wet, unmowed grass runway.Jul 23, 1998 · N5643V · Substantial damageNTSB NYC98LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Rockland, METhe pilot's failure to attain adequate airspeed during the takeoff, which resulted in a stall.Jul 19, 1998 · N5755F · DestroyedNTSB IAD98LA080Accident · No injuriesLimited investigationFinal reportAeronca 7FC · Somesville, METhe pilot's inadequate planning and decision, which fail to consider the effect of takeoff in the direction of the sunlight, which resulted in the pilot encountering sunglare and the loss of aircraft control.Jul 19, 1998 · N7694E · Substantial damageNTSB IAD98LA078Accident · Serious injuriesLimited investigationFinal reportMastopietro Rans S12 · Phillips, MELoss of engine power due to a separated oil line. A related factor was the unsuitable field.Jul 9, 1998 · N6191V · Substantial damageNTSB NYC98LA135Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-65 · West Buxton, MEfailure of the pilot to see-and-avoid power lines (inadequate visual lookout), as he was approaching to make a water landing on a river.Jun 28, 1998 · N47893 · Substantial damageNTSB NYC98FA092Accident · 1 fatalField investigationFinal reportAerostar 600A · Mapleton, MEthe failure of the pilot to maintain control of the airplane during takeoff for undetermined reasons.Apr 10, 1998 · N7527S · DestroyedNTSB NYC98FA071Accident · 2 fatalField investigationFinal reportPiper PA-31-310 · Presque Isle, METhe pilot's failure to follow the published instrument approach procedure and his descent below the minimum descent altitude. Contributing factors were the night conditions, low ceilings, and fog.Mar 1, 1998 · N777HM · DestroyedNTSB NYC98LA070Accident · No injuriesLimited investigationFinal reportCessna 320F · Lincoln, METhe pilot's failure to maintain adequate altitude which resulted in left main landing gear contacting a snowbank during the landing approach.Feb 27, 1998 · N6189Q · Substantial damageNTSB IAD98LA019Accident · No injuriesLimited investigationFinal reportCessna 172P · Augusta, METhe inadequate lookout of the pilot in command.Jan 2, 1998 · N9912L · Substantial damageNTSB NYC97LA153Accident · No injuriesLimited investigationFinal reportCessna 185 · Norway, METhe pilot's failure to maintain control of the airplane while maneuvering to avoid an obstacle.Jul 25, 1997 · N8717Z · Substantial damageNTSB IAD97FA095Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Penobscot, METhe pilot's flight into adverse weather conditions, which resulted in the loss of control. Factors relating to the accident were the fog and the pilot's lack of an instrument rating.Jul 3, 1997 · N3896T · DestroyedNTSB NYC97LA111Accident · No injuriesLimited investigationFinal reportCessna 150K · Jay, MEthe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.Jun 8, 1997 · N6218G · Substantial damageNTSB NYC97LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Clayton Lake, MEthe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an inadvertent stall, and uncontrolled descent to the frozen lake surface.Mar 28, 1997 · N2852M · DestroyedNTSB NYC97LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Sanford, MEthe pilot's premature raising of the flaps during the initial climb after takeoff, which resulted in a stall/mush. A factor relating to the accident was: the pilot's failure to maintain proper runway alignment after lift-off, which allowed the airplane to…Mar 14, 1997 · N2914A · Substantial damageNTSB IAD97LA050Accident · No injuriesLimited investigationFinal reportCessna 150 · Turner, MELoss of engine power for undetermined reasons. A related factor was the snowbank.Feb 19, 1997 · N7811E · Substantial damageNTSB NYC97FA045Accident · Minor injuriesField investigationFinal reportBeech 1900D · Bangor, METhe inadequate flight and winter operations training provided by the operator, and the pilot's improper decision to abort the takeoff while airborne above V1, due to a false stall warning horn. Also casual was the airport operations improper decision to…Jan 10, 1997 · N139ZV · Substantial damageNTSB NYC97LA037Accident · 1 fatalLimited investigationFinal reportRichardson Kitfox 4 · Trenton, MEfailure of the pilot to maintain adequate airspeed while maneuvering after takeoff, which resulted in a stall/spin and an uncontrolled descent into terrain. The airplane's excessive gross weight was a related factor.Dec 24, 1996 · N922VR · DestroyedNTSB NYC97LA034Accident · No injuriesLimited investigationFinal reportMaule M-5 · Levant, MEthe pilot's inadequate compensation for wind conditions, and his failure to maintain clearance from tree(s) during an attempted go-around. The crosswind and proximity of tree(s) were related factors.Dec 21, 1996 · N56391 · Substantial damageNTSB IAD96LA144Accident · No injuriesLimited investigationFinal reportCessna 150L · Hope, MEinadequate preflight, by not refueling the airplane during an en route stop, which led to fuel exhaustion, loss of engine power, and a subsequent forced landing.Sep 6, 1996 · N6632G · Substantial damageNTSB NYC96LA180Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, MEthe student pilot's improper flare, which resulted in at hard landing.Sep 1, 1996 · N2009A · Substantial damageNTSB NYC96LA167Accident · No injuriesLimited investigationFinal reportBell 206B · Starks, MEthe pilot's improper decision to operate at slow airspeed, and close to the critical relative wind azimuth area in gusty, variable winds, which resulted in an inadvertent loss of tail rotor effectiveness. The gusty crosswind and lack of a suitable terrain for…Aug 13, 1996 · N9913K · Substantial damageNTSB NYC96LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Castine, MEthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. Factors relating to the accident were: false indication from the fuel quantity gauge, and soft terrain in the emergency…Jul 28, 1996 · N65530 · Substantial damageNTSB NYC96FA157Accident · 2 fatalField investigationFinal reportCessna 182P · Brewer, MEfailure of the pilot to maintain control of the airplane, during a missed approach, after diverting to an alternate destination, while on his first solo flight in instrument meteorological conditions (IMC).Jul 24, 1996 · N9920E · DestroyedNTSB NYC96LA155Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Turner, MEthe pilot's inadequate preflight inspection, by failing to remove the pitot tube cover, which resulted in false airspeed indications, and his failure to maintain adequate obstacle clearance from a utility pole.Jul 23, 1996 · N3269J · Substantial damageNTSB NYC96FA123Accident · 2 fatalField investigationFinal reportBeech E90 · Woolwich, MEfailure of the pilot to maintain control of the airplane while climbing after takeoff, due to spatial disorientation, which resulted in an uncontrolled descent and subsequent collision with terrain. Factors relating to the accident were: the improper…Jun 10, 1996 · N916PA · DestroyedNTSB IAD96FA090Accident · 1 fatalField investigationFinal reportCessna 320C · Winslow, MEthe pilot's continued flight into known adverse weather conditions, and his loss of aircraft control, which resulted in an uncontrolled descent into terrain (river). The known icing condition was a related factor.Jun 3, 1996 · N78KA · DestroyedNTSB NYC96LA091Accident · No injuriesLimited investigationFinal reportCessna 140 · Houlton, MEthe pilot's failure to select the fullest fuel tank prior to takeoff which resulted in fuel starvation during the initial takeoff climb.Apr 25, 1996 · N2001N · Substantial damageNTSB NYC96LA074Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Shirley, MEthe pilot's fuel mismanagement and improper use of the fuel selector valve which resulted in fuel starvation.Mar 11, 1996 · N712MY · Substantial damageNTSB NYC96LA059Accident · No injuriesLimited investigationFinal reportCessna 180D · Islesboro, MEa loss of engine power for an undetermined reason.Feb 5, 1996 · N6423X · Substantial damageNTSB NYC96LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Auburn, METhe pilot's improper planning/decision and failure to attain proper alignment with the landing area. Factors relating to the accident were: darkness, and the inoperative radio transmitter, which precluded the pilot from activating the runway lights.Jan 16, 1996 · N913A · Substantial damageNTSB NYC96LA041Accident · No injuriesLimited investigationFinal reportCessna U206G · Bangor, MEthe pilot's improper inflight planning/decision, and his failure to properly plan his approach for landing, so that the airplane would not stall or touchdown hard. Factors relating to the accident were: the adverse weather (icing) condition, the accumulation…Dec 16, 1995 · N6250X · Substantial damageNTSB NYC96LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Sanford, MEthe pilot's failure to adequately compensate for a crosswind during the landing roll, which resulted in a collision with a snowbank. Factors relating to the accident were: ice on the runway and the gusty crosswind condition.Dec 12, 1995 · N734QZ · Substantial damageNTSB NYC96IA022Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Portland, MEa bird strike during takeoff, which resulted in failure of several fan blades in the right engine and a partial loss of engine power.Nov 2, 1995 · N373US · Minor damageNTSB NYC96LA017Accident · No injuriesLimited investigationFinal reportCessna 182B · Lebanon, MEthe pilot's improper use of the mixture control which resulted in fuel starvation and loss of engine power.Oct 22, 1995 · N2754G · Substantial damageNTSB NYC95LA216Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Boothbay Harbor, MEthe pilot's misjudgment of distance and altitude, while on final approach to land. Factors relating to the accident were: sunglare, and the pilot's lack of visual cues (visual perception).Sep 3, 1995 · N98503 · Substantial damageNTSB NYC95FA210Accident · 3 fatalField investigationFinal reportCessna 172M · Portland, MEan engine malfunction for an undetermined reason, and the pilot's failure to maintain airspeed during a forced landing which resulted in an accelerated stall. A factor was the pilot's lack of recent experience.Sep 1, 1995 · N6564H · DestroyedNTSB NYC95LA198Accident · Minor injuriesLimited investigationFinal reportBell 206B · Bingham, MEthe pilot's inadequate landing flare resulting in a hard landing and roll over, and a subsequent collision with trees.Aug 18, 1995 · N16915 · DestroyedNTSB NYC95FA188Accident · 1 fatalField investigationFinal reportBeech 58 · Mapleton, METhe pilot inadvertently shut down the right engine and feathered the propeller after a loss of power in the left engine, and he failed to maintain adequate airspeed, which resulted in an inadvertent stall/spin and collision with the ground. A factor relating…Aug 14, 1995 · N168CG · DestroyedNTSB BFO95LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Phillips, MEthe private pilot's failure to obtain/maintain altitude/clearance from obstacles during the takeoff/initial climb. Related factors are the grass/turf runway, the improper weight and balance, and the tailwind.Jun 19, 1995 · N91469 · DestroyedNTSB NYC95LA094Accident · No injuriesLimited investigationFinal reportCessna 172G · Augusta, METhe student pilot's delay in aborting the landing attempt. The crosswind, and the pilot's inadequate compensation for the crosswind were factors.Apr 25, 1995 · N3799L · Substantial damageNTSB NYC95LA093Accident · No injuriesLimited investigationFinal reportCessna 185 · Bangor, MEthe pilot's improper flare, which resulted in a hard landing and collapse of the right main gear.Apr 24, 1995 · N62EC · Substantial damageNTSB BFO95LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Belfast, MEthe student pilot's failure to adequately compensate for wind conditions. A related factor was the presence of high snowbanks along the sides of the runway.Mar 4, 1995 · N5554Z · Substantial damageNTSB NYC95LA036Accident · No injuriesLimited investigationFinal reportPiper J3C · Waldoboro, METhe pilot's premature lift off which resulted in insufficient climb performance and collision with trees.Nov 25, 1994 · N98542 · Substantial damageNTSB NYC95LA037Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glenburn, METhe pilot's (1) improper decision to initiate a takeoff with ice on the wing.Nov 24, 1994 · N112KF · Substantial damage