Final NTSB investigations, 2011

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 year(c.\"eventDate\") = 2011
    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 ERA12FA018Accident · 1 fatalField investigationFinal reportBerger Michael A Waiex · Washington, GAThe in-flight failure of the aircraft’s Y-tail attachment structure during maneuvering flight due to overload. Contributing to the accident was, the kit manufacturer’s use of 14 CFR Part 23, Appendix A design guidelines intended for a conventional tail…Oct 22, 2011 · N75654 · Substantial damageNTSB ERA12CA019Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Manassas, VAThe pilot did not maintain adequate airspeed while turning to the downwind leg, which resulted in an aerodynamic stall and spin.Oct 22, 2011 · N4300E · Substantial damageNTSB ANC12CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Portage, AKThe pilot's selection of unsuitable terrain for landing.Oct 22, 2011 · N82481 · Substantial damageNTSB ANC12CA004Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Aniak, AKThe pilot's excessive use of brakes during landing.Oct 22, 2011 · N11668 · Substantial damageNTSB WPR12LA015Accident · Minor injuriesLimited investigationFinal reportPiper PA46R · Paso Robles, CAA loss of engine power while maneuvering for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Oct 21, 2011 · N422HP · Substantial damageNTSB CEN12CA035Accident · Minor injuriesData collectionFinal reportHouts Avid Mark IV · Hibbing, MNThe improper installation of a hose clamp, which resulted in an oil line rupture and subsequent loss of engine oil pressure.Oct 21, 2011 · N43280 · Substantial damageNTSB ERA12CA044Accident · Serious injuriesData collectionFinal reportBoeing 767-2B7 · New York, NYThe passenger's lack of compliance with the illuminated seatbelt sign, which resulted in her injury during a turbulence encounter.Oct 20, 2011 · N253AY · No damageNTSB CEN12CA044Accident · No injuriesData collectionFinal reportAviat A-1 · Wolverton, MNThe pilot's inadvertent excessive braking during the landing roll due to momentary pain.Oct 20, 2011 · N93HU · Substantial damageNTSB WPR12CA016Accident · No injuriesData collectionFinal reportBeech D17S · Phoenix, AZThe pilot's failure to extend the landing gear.Oct 18, 2011 · N44562 · Substantial damageNTSB ERA12LA045Accident · No injuriesLimited investigationFinal reportGraff Wilbur C Bearhawk · Woodrow, WVThe pilot’s delayed use of carburetor heat while operating in conditions conducive to carburetor icing.Oct 18, 2011 · N5456C · Substantial damageNTSB ERA12CA042Accident · Minor injuriesData collectionFinal reportMoyes Bailey Dragonfly · Massey, MDThe pilot did not maintain airspeed during approach to landing, which resulted in an aerodynamic stall.Oct 18, 2011 · N103ST · Substantial damageNTSB CEN12CA028Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Brookings, SDThe pilot's inadequate compensation for gusty wind conditions while landing.Oct 18, 2011 · N8485D · Substantial damageNTSB ERA12LA034Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Newnan, GAA total loss of engine power for undetermined reasons.Oct 17, 2011 · N828MA · Substantial damageNTSB ERA12LA033Accident · No injuriesLimited investigationFinal reportCessna R172K · Williamsburg, VAA total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Oct 17, 2011 · N758GY · Substantial damageNTSB ERA12FA030Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Danbury, CTThe pilot did not maintain clearance from a lighted tower during final approach in night visual conditions.Oct 17, 2011 · N438CP · Substantial damageNTSB ERA12CA043Accident · Minor injuriesData collectionFinal reportFehlner-Shelton Aerosport Scamp WTB1 · Grantham, NCThe pilot's inadequate clearance from unmarked power lines while on approach to land at a private airport.Oct 17, 2011 · N25WS · Substantial damageNTSB ERA12CA036Accident · Serious injuriesData collectionFinal reportCessna 172F · Atlanta, GAThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.Oct 17, 2011 · N5419R · Substantial damageNTSB ERA12CA035Accident · Serious injuriesData collectionFinal reportAmerican Champion 7AC · Berkley, MAThe pilot did not maintain clearance from a tree during the final approach in solar glare conditions.Oct 17, 2011 · N3662E · Substantial damageNTSB CEN12FA025Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Watertown, WIThe separation of the number 2 connecting rod from the crankshaft for reasons that could not be determined during postaccident metallurgical examination, which ultimately resulted in a total loss of engine power.Oct 17, 2011 · N300KR · Substantial damageNTSB CEN12CA030Accident · No injuriesData collectionFinal reportCessna 172N · Covington, LAThe pilot’s failure to maintain adequate airspeed during a banner drop, resulting in an aerodynamic stall.Oct 17, 2011 · N2401E · Substantial damageNTSB WPR12FA012Accident · 3 fatalField investigationFinal reportBeech E33 · Daggett, CAA loss of engine power due to the separation of a connecting rod, and the pilot's failure to maintain airplane control during a sudden maneuver to avoid power lines during the descent, which resulted in an unrecoverable aerodynamic stall and subsequent spin.…Oct 16, 2011 · N7011N · Substantial damageNTSB WPR12CA014Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Las Vegas, NVThe inadvertent opening of the airplane’s canopy during takeoff, which distracted the pilot and resulted in his failure to maintain control of the airplane. Contributing to the accident was the pilot's failure to comply with the manufacturer's recommended…Oct 16, 2011 · N999VS · Substantial damageNTSB ERA12CA040Accident · No injuriesData collectionFinal reportEngineering & Research 415-C · Mebane, NCThe pilot's delay in aborting the takeoff.Oct 16, 2011 · N3760H · Substantial damageNTSB CEN12FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Guthrie, OKThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Oct 16, 2011 · N6085W · Substantial damageNTSB CEN12CA038Accident · No injuriesData collectionFinal reportPipistrel Sinus 912 · Indianapolis, INThe pilot's failure to maintain directional control of the motor-glider while landing in gusty wind conditions.Oct 16, 2011 · N9013H · Substantial damageNTSB CEN12CA026Accident · Serious injuriesData collectionFinal reportJantzen Evans VP · Terrell, TXThe pilot’s inadequate preflight planning, in that he did not determine whether the airplane’s climb performance would be sufficient to clear obstacles before initiating take off.Oct 16, 2011 · N331EJ · Substantial damageNTSB CEN12CA024Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Moriarty, NMThe pilot's failure to maintain control of the airplane during the landing roll.Oct 16, 2011 · N415WW · Substantial damageNTSB WPR12LA013Accident · Minor injuriesLimited investigationFinal reportMiller Avid Flyer · Susanville, CAA total loss of engine power during the takeoff climb for undetermined reasons.Oct 15, 2011 · N4077B · Substantial damageNTSB OPS12IA041Incident · No injuriesIncident investigationFinal reportCessna 172S · Daytona Beach, FLThe departing pilot's incorrect runway selection and non-compliance with an air traffic control clearance. Contributing to the incident was the air traffic controller's inadequate monitoring of the departing aircraft to ensure that the pilot complied with the…Oct 15, 2011 · N488ER · 2 aircraft · No damageNTSB ERA12CA037Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Deland, FLThe pilot's inadequate directional control during the landing roll.Oct 15, 2011 · N929SC · Substantial damageNTSB ERA12CA029Accident · No injuriesData collectionFinal reportCessna 180H · Houston, MSThe pilot did not maintain directional control during the landing roll.Oct 15, 2011 · N4764U · Substantial damageNTSB CEN12LA047Accident · Serious injuriesLimited investigationFinal reportSaber Trike unk · Okmulgee, OKThe in-flight collision with electrical wires for undetermined reasons.Oct 15, 2011 · UNREG · Substantial damageNTSB CEN12CA032Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Radnor, OHThe pilot's failure to properly secure the engine controls prior to manually rotating the propeller, which led to an inadvertent engine start and runaway airplane.Oct 15, 2011 · N8746W · Substantial damageNTSB CEN12CA029Accident · Minor injuriesData collectionFinal reportHunt Sparrowhawk · Blair, NEThe pilot/builder’s inadequate installation of a nosewheel steering component, which resulted in a shimmy and a loss of directional control during the takeoff roll.Oct 15, 2011 · N29HT · Substantial damageNTSB WPR12CA011Accident · Minor injuriesData collectionFinal reportCessna 170B · Ramona, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll.Oct 14, 2011 · N8261A · Substantial damageNTSB ERA12CA027Accident · No injuriesData collectionFinal reportIca Brasov IS-29D2 · Benton, TNThe pilot's improper in-flight planning, which resulted in a low-altitude traffic pattern entry and subsequent collision with telephone wires.Oct 14, 2011 · N1339X · Substantial damageNTSB CEN12CA031Accident · No injuriesData collectionFinal reportHughes 269A · Fort Worth, TXThe inadvertent entry into ground resonance after a hovering autorotation.Oct 14, 2011 · N10375 · Substantial damageNTSB CEN12CA027Accident · No injuriesData collectionFinal reportMichael Cans RV-8 · Breaux Bridge, LAThe pilot's failure to maintain control of the airplane after striking an unseen sinkhole during landing.Oct 14, 2011 · N610EC · Substantial damageNTSB CEN12CA022Accident · No injuriesData collectionFinal reportCessna 172P · Ozark, MOThe pilot’s inadequate compensation for gusty crosswind conditions while on approach.Oct 14, 2011 · N54356 · Substantial damageNTSB WPR12LA009Accident · No injuriesLimited investigationFinal reportSpink Robert M Pietenpol Aircamper · San Rafael, CAA total loss of engine power during the takeoff climb due to fuel starvation, which resulted from the incorrect installation location of the fuel tank supply line screen that allowed debris to partially block the fuel supply line.Oct 13, 2011 · N762S · Substantial damageNTSB WPR12FA010Accident · 1 fatalField investigationFinal reportDG Flugzeugbau DG 1000S · Cle Elum, WAThe pilot’s failure to maintain airspeed and control after takeoff, which resulted in an aerodynamic stall.Oct 13, 2011 · N7760A · Substantial damageNTSB WPR12CA007Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A · San Diego, CAThe pilot's excessive brake application during landing.Oct 13, 2011 · N502GL · Substantial damageNTSB ERA12FA051Accident · 1 fatalField investigationFinal reportCessna 150F · Moncks Corner, SCThe debilitating effects of ethylene glycol poisoning, which resulted in the pilot’s inability to maintain control of the airplane.Oct 13, 2011 · N3086X · Substantial damageNTSB WPR12CA008Accident · No injuriesData collectionFinal reportCessna 172P · Cornelius, ORThe airplane’s encounter with an unseen hole or obstacle on the grass runway.Oct 12, 2011 · N52013 · Substantial damageNTSB ERA12FA023Accident · Minor injuriesField investigationFinal reportSocata TBM 700 · Hollywood, FLThe pilot’s failure to terminate the flight after observing multiple conflicting errors associated with the inaccurate right fuel quantity indication. Contributing to the accident were the total loss of engine power due to fuel starvation from the right tank,…Oct 12, 2011 · N37SV · Substantial damageNTSB ERA12CA168Accident · No injuriesData collectionFinal reportMaule MX-7-180C · Zelienople, PAThe pilot did not maintain directional control during landing.Oct 12, 2011 · N567HW · Substantial damageNTSB ERA12CA046Accident · No injuriesData collectionFinal reportCessna 182L · Gainesville, FLThe pilot did not maintain a proper descent rate during the approach, which resulted in a hard landing.Oct 12, 2011 · N42547 · Substantial damageNTSB CEN12CA017Accident · No injuriesData collectionFinal reportLearjet 60 · Lafayette, INThe pilot's decision to taxi the airplane across an unpaved area after the nosewheel inadvertently departed the ramp pavement.Oct 12, 2011 · N64MG · Substantial damageNTSB CEN12CA016Accident · No injuriesData collectionFinal reportCessna 182A · Skiatook, OKA total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel management.Oct 12, 2011 · N6171B · Substantial damageNTSB WPR12CA005Accident · No injuriesData collectionFinal reportCombs Dale B RV-4 · Madera, CAThe third airplane pilot’s failure to maintain visual contact with the second airplane during the formation flight.Oct 11, 2011 · N506DC · 2 aircraft · Substantial damage