NTSB investigations

19,222 cases where NTSB found Aircraft.

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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01'))
  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 GAA18CA317Accident · No injuriesData collectionFinal reportAeronca 7AC · Vinton, IAThe pilot’s failure to maintain directional control while landing in gusting tailwind conditions.May 28, 2018 · N84163 · Substantial damageNTSB GAA18CA315Accident · No injuriesData collectionFinal reportJim Green CCX · Couer D'Alene, IDThe pilot’s failure to maintain directional control during landing in gusting wind conditions.May 28, 2018 · N18JG · Substantial damageNTSB GAA18CA311Accident · Minor injuriesData collectionFinal reportMaule M5 · Lewiston, IDThe pilot’s failure to maintain the runway centerline and his subsequent decision to not perform a go-around, which resulted in the main landing gear contacting tall wheat and a subsequent loss of control.May 28, 2018 · N5634Y · Substantial damageNTSB GAA18CA308Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Cedar Key, FLThe airplane’s collision with multiple birds during initial climb, which damaged the propeller and resulted in a subsequent aerodynamic stall because the airspeed could not be maintained.May 28, 2018 · N269DW · Substantial damageNTSB GAA18CA302Accident · No injuriesData collectionFinal reportTaylorcraft F21 · Payette, IDThe student pilot’s failure to maintain directional control during landing with a crosswind and his subsequent failure to maintain airspeed during an aborted landing, which resulted in a collision with terrain and nose-over.May 28, 2018 · N2004U · Substantial damageNTSB CEN18LA199Accident · Serious injuriesLimited investigationFinal reportAeronca 58B · Tekamah, NEThe partial loss of engine power due to the formation of carburetor ice. Contributing to the accident was the pilot's failure to use carburetor heat and his decision to continue flight with reduced engine power rather than landing the airplane on suitable…May 28, 2018 · N47252 · Substantial damageNTSB CEN18LA197Accident · Minor injuriesLimited investigationFinal reportFairchild M 62C(PT-23A) · Wichita, KSA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s miscalculation of the fuel consumption rate during preflight planning.May 28, 2018 · N64176 · Substantial damageNTSB ANC18LA039Accident · No injuriesLimited investigationFinal reportCessna T182T · Yerington, NVLoss of directional control during landing for reasons that could not be determined based on the available evidence, which resulted in a runway excursion.May 28, 2018 · N68AX · Substantial damageNTSB WPR18FA150Accident · 2 fatalField investigationFinal reportMorrison Marvin E JR RV 6A · Petaluma, CAA partial loss of engine power during initial climb after takeoff due to a loose left magneto, and the pilot's decision to turn back to the airport and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/spin and…May 27, 2018 · N4269Y · Substantial damageNTSB GAA18CA325Accident · Minor injuriesData collectionFinal reportCosentino Garey A Pegasus · Kingston, OKThe pilot’s failure to maintain altitude and the powered parachute’s subsequent impact with trees.May 27, 2018 · N339PG · Substantial damageNTSB GAA18CA307Accident · No injuriesData collectionFinal reportPiper PA28 · Butler, KYThe pilot’s improper fuel management, which resulted in fuel starvation.May 27, 2018 · N95410 · Substantial damageNTSB GAA18CA306Accident · No injuriesData collectionFinal reportLite Flight Dragonfly · Mint Hill, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a turn, which resulted in an aerodynamic stall/spin.May 27, 2018 · N582DF · Substantial damageNTSB GAA18CA305Accident · Minor injuriesData collectionFinal reportZS Delta-Bielsko Wroclaw SZD 36 A Cobra 15 · Hammond, ILThe pilot’s loss of directional control during an off-airport landing and his subsequent failure to maintain clearance from power pole guy wires.May 27, 2018 · N1075G · Substantial damageNTSB GAA18CA303Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot’s failure to maintain directional control during the landing roll with a tailwind.May 27, 2018 · N4018E · Substantial damageNTSB GAA18CA301Accident · No injuriesData collectionFinal reportEldridge George Skystar Kitfox SER 7 · Weippe, IDThe pilot’s failure to maintain a proper approach altitude, which resulted in a collision with a fence.May 27, 2018 · N103GE · Substantial damageNTSB CEN18LA195Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Katy, TXThe loss of airplane control on takeoff due to the absence of the attachment bolt for the left aileron actuation arm.May 27, 2018 · N67Y · Substantial damageNTSB CEN18LA194Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Qulin, MOThe pilot’s improper weight-and-balance calculations and his decision to take off with the airplane at a high gross weight in high density altitude conditions, which resulted in an attempted takeoff that exceeded the airplane’s performance capability. Also…May 27, 2018 · N6180J · Substantial damageNTSB CEN18FA193Accident · 2 fatalField investigationFinal reportBeech P35 · Omaha, NEThe pilot's loss of directional control and his failure to abort the takeoff, which resulted in a runway excursion and collision with terrain.May 27, 2018 · N263CE · DestroyedNTSB WPR18LA148Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Hillsboro, ORThe partial loss of engine power during a go-around due to the loose copper electrode finger inside the left magneto.May 26, 2018 · N152GB · Substantial damageNTSB GAA18CA326Accident · No injuriesData collectionFinal reportCessna 172 · Westminster, MDThe pilot’s improper landing flare, which resulted in a hard landing.May 26, 2018 · N789EP · Substantial damageNTSB ERA18LA155Accident · No injuriesClass 3 · LimitedFinal reportDevries WM H Kitfox Sport · Taghkanic, NYA total loss of engine power for reasons that could not be determined based on the available information.May 26, 2018 · N47DV · Substantial damageNTSB WPR18LA147Accident · Serious injuriesClass 3 · LimitedFinal reportBell UH 1H · Olympia, WAA loss of tail rotor thrust due to the improper installation of the tail rotor assembly by maintenance personnel resulted in the pilot’s inability to maintain control of the helicopter as he began transition into forward flight from a hover, which resulted in…May 25, 2018 · N111DR · Substantial damageNTSB CEN18FA192Accident · 1 fatalField investigationFinal reportBeech D17S · Santa Fe, NMThe pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available information.May 25, 2018 · N79091 · Substantial damageNTSB GAA18CA343Accident · Serious injuriesData collectionFinal reportAmerican AA · Port Orange, FLThe pilot’s inadequate preflight inspection of the fuel, which resulted in fuel exhaustion and a subsequent total loss of engine power.May 24, 2018 · N5787L · Substantial damageNTSB GAA18CA295Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Batavia, OHThe student pilot’s use of an improper engine hand-propping procedure, which resulted in the airplane’s unexpected movement.May 24, 2018 · N77922 · Substantial damageNTSB ANC18LA038Accident · Minor injuriesLimited investigationFinal reportJames Wiebe Belite Pipper · Anchorage, AKAn inadequate fuel supply to the engine, which resulted in a total loss of engine power and subsequent impact with terrain.May 24, 2018 · N3748 · Substantial damageNTSB GAA18CA298Accident · No injuriesData collectionFinal reportGarcia Benigno Baby ACE D · St. Johns, AZThe pilot’s failure to maintain directional control during landing in gusting, quartering tailwind conditions.May 23, 2018 · N4207D · Substantial damageNTSB GAA18CA297Accident · Minor injuriesData collectionFinal reportPiper PA22 · Start, LAThe pilot’s improper landing flare, which resulted in a bounced landing.May 23, 2018 · N4913Z · Substantial damageNTSB WPR18LA145Accident · Minor injuriesLimited investigationFinal reportSportavia Putzer RF5B Sperber · Lookout Pass, MTThe pilot’s improper decision to continue flight toward rising terrain after the engine overheated, which necessitated a precautionary landing when the motorglider could not maintain altitude in downdrafts.May 22, 2018 · N66GL · Substantial damageNTSB WPR18CA146Accident · No injuriesData collectionFinal reportAyres S2R G10 · Marysville, CAThe pilot’s failure to maintain clearance from a truck while on final approach after the airplane encountered a downdraft, which resulted in the subsequent failure of the right main landing gear and loss of directional control.May 22, 2018 · N32064 · Substantial damageNTSB GAA18CA293Accident · No injuriesData collectionFinal reportCessna 150 · Bemidgi, MNThe student pilot’s failure to maintain lateral control of the airplane during the landing roll, which resulted in a side load and subsequent failure of the left main landing gear extension casting.May 22, 2018 · N5999T · Substantial damageNTSB ERA18FA152Accident · 1 fatalField investigationFinal reportCessna 140 · Daytona Beach, FLThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation during the initial climb, and his failure to maintain adequate airspeed while turning back to the runway, which resulted in an exceedance of the…May 22, 2018 · N89864 · DestroyedNTSB CEN18LA189Accident · Serious injuriesClass 3 · LimitedFinal reportM-Squared Sprint 1000 · Gurdon, ARInadequate engine maintenance, which resulted in the failure of the MAG piston ring and the subsequent total loss of engine power due to a piston seizure.May 22, 2018 · N138ZX · Substantial damageNTSB CEN18FA186Accident · 1 fatalField investigationFinal reportJames Donald Baker Zenith · Bolivar, MOThe pilot's failure to maintain airplane control after takeoff.May 22, 2018 · N622DP · DestroyedNTSB WPR18LA158Accident · No injuriesClass 3 · LimitedFinal reportRhoads Autogyro MTO Sport · San Manuel, AZThe fracture of the propeller hub due to corrosion pitting along the propeller blade root seat, which led to cracking that was propagated due to high-cycle fatigue.May 21, 2018 · N574BR · Substantial damageNTSB WPR18LA153Accident · No injuriesLimited investigationFinal reportPiper PA24 · San Jose, CAA landing gear retraction during the landing rollout for reasons that could not be determined based on the available evidence.May 21, 2018 · N244TW · Substantial damageNTSB GAA18CA291Accident · Minor injuriesData collectionFinal reportPiper PA28 · Farmingdale, NYThe pilot’s exceedance of the airplane’s critical angle of attack during short final, which resulted in an aerodynamic stall and hard landing.May 21, 2018 · N5560W · Substantial damageNTSB ERA18LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Sandersville, GAA nose landing gear collapse for reasons that could not be determined based on the available information.May 21, 2018 · N427JM · Substantial damageNTSB ERA18FA149Accident · 1 fatalField investigationFinal reportTaylorcraft BC12 · Commerce, GAThe pilot's failure to effectively mitigate an accumulation of carburetor ice, which resulted in an undetected partial loss of engine power and an aerodynamic stall during takeoff.May 21, 2018 · N94909 · Substantial damageNTSB GAA18CA290Accident · No injuriesData collectionFinal reportPiper PA 14 · Vashon, WAThe pilot’s failure to maintain directional control of the airplane during the takeoff roll due to his right foot inadvertently applying pressure to both rudder pedals.May 20, 2018 · N1423P · Substantial damageNTSB GAA18CA288Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Marlborough, MAThe pilot’s improper decision to land on a runway that was too short for a safe landing and his subsequent failure to maintain directional control in tailwind conditions.May 20, 2018 · N143RD · Substantial damageNTSB ERA18FA148Accident · 1 fatalField investigationFinal reportPiper PA34 · Bennington, VTThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in a loss of control during a turn.May 20, 2018 · N1101X · DestroyedNTSB WPR18FA143Accident · 1 fatalField investigationFinal reportI.C.A.-Brasov IS 29D · Avenal, CAThe pilot's improper installation of the wings onto the glider, which resulted in an in-flight wing separation. Contributing to the accident were the pilot's limited familiarity with the design and a lack of reliable assembly guidance.May 19, 2018 · N38ES · DestroyedNTSB GAA18CA477Accident · Minor injuriesData collectionFinal reportDavidson, Ronald A. Avid · Moab, UTThe pilot's excessive brake application and delayed remedial action, which resulted in a nose over.May 19, 2018 · N833RD · Substantial damageNTSB GAA18CA309Accident · No injuriesData collectionFinal reportAir Tractor AT 402 · Nicolaus, CAThe pilot’s failure to maintain adequate clearance from a power transmission wire.May 19, 2018 · N5128N · Substantial damageNTSB GAA18CA299Accident · No injuriesData collectionFinal reportCessna 172 · Defuniak Springs, FLThe student pilot’s failure to maintain directional control during the aborted landing.May 19, 2018 · N12267 · Substantial damageNTSB GAA18CA287Accident · No injuriesData collectionFinal reportMaule M 7 · Burnet, TXThe pilot’s failure to maintain directional control during landing in gusting wind conditions and with an incorrect flap configuration.May 19, 2018 · N427LS · Substantial damageNTSB CEN18LA183Accident · Serious injuriesLimited investigationFinal reportHughes 369A · Stoneburg, TXThe pilot's unsafe and aggressive operation of the helicopter at low altitude, which resulted in impact with trees.May 19, 2018 · N369GK · DestroyedNTSB CEN18LA181Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV7A · Hanover Park, ILA partial loss of engine power shortly after takeoff due to water contamination of the fuel system.May 19, 2018 · N667AZ · Substantial damageNTSB GAA18CA289Accident · No injuriesData collectionFinal reportAerospatiale AS350 B2 Ecureuil · Yakutat, AKThe helicopter’s movement during startup in gusting wind conditions, which resulted in the main rotor striking the tailboom.May 18, 2018 · N288CH · Substantial damage