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 CEN21LA373Accident · No injuriesClass 4 · LimitedFinal reportMooney M20F · New Albany, MSThe pilot’s delayed decision to abort the landing that resulted in a collision with a fence post. Contributing to the accident was the failure of the alternator drive belt during cruise flight for unknown reasons and the subsequent inoperative electrical…Jul 22, 2021 · N6474Q · Substantial damageNTSB ERA21LA298Accident · No injuriesClass 3 · LimitedFinal reportCarpenter Stol CH750 · Rockwell, NCThe total loss of engine power due to carburetor ice. Also causal was the pilot’s failure to apply carburetor heat at any time during the flight.Jul 21, 2021 · N750RS · Substantial damageNTSB ERA21LA296Accident · No injuriesClass 4 · LimitedFinal reportCessna 560XL · Reading, PAThe captain’s improper decision to continue an unstabilized approach despite several go-around calls by the pilot monitoring, which resulted in a runway excursion and substantial damage to the pressure vessel.Jul 21, 2021 · N46CF · Substantial damageNTSB CEN21LA332Accident · No injuriesClass 4 · LimitedFinal reportMadera RV-3 · Jacksonville, ILThe pilot’s improper flare during landing which resulted in an attempted go-around, loss of control, and aerodynamic stall.Jul 21, 2021 · N3S · Substantial damageNTSB ERA21LA295Accident · 2 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Point Harbor, NCThe noncertificated pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation over a large body of water and a high velocity impact with the water. Contributing to the accident…Jul 19, 2021 · N4529J · DestroyedNTSB ERA21LA294Accident · No injuriesClass 4 · LimitedFinal reportTurbine Cubs Of Wyoming PA-18 Super CUB · Dinwiddie, VAThe pilot’s failure to maintain control while taxiing on soft ground, which resulted in a nose-over.Jul 19, 2021 · N507TC · Substantial damageNTSB CEN21LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Brenham, TXThe pilot’s failure to maintain control of the airplane during takeoff from a rough field.Jul 19, 2021 · N9024M · Substantial damageNTSB CEN21FA330Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Elgin, MNThe pilot’s decision to operate the helicopter under powerlines, which resulted in a main rotor blade striking a powerline, causing the helicopter to descend from a low altitude and impact terrain.Jul 19, 2021 · N44BJ · DestroyedNTSB ANC21LA062Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK 1 · King Salmon, AKThe pilot’s exceedance of the floatplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent loss of control.Jul 19, 2021 · N68080 · Substantial damageNTSB WPR21LA281Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Cascade, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and collision with terrain.Jul 18, 2021 · N2712A · Substantial damageNTSB ERA21LA293Accident · Minor injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Frostproof, FLThe pilot’s loss of directional control during takeoff as a result of a child reaching for and manipulating the flight controls.Jul 18, 2021 · N3044H · Substantial damageNTSB CEN21LA325Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35-C33 · Longmont, COThe airplane’s lack of climb performance after takeoff in high density altitude conditions for reasons that could not be determined based on the available evidence.Jul 18, 2021 · N18AR · Substantial damageNTSB CEN21LA326Accident · Serious injuriesClass 3 · LimitedFinal reportGary James Lail Zenith CH 750 Cruzer · Blossom, TXThe improper swaging of the rudder control cable, which disconnected during flight and resulted in the loss of control.Jul 17, 2021 · N9667Z · Substantial damageNTSB WPR21FA273Accident · 3 fatalClass 3 · FieldFinal reportBeech V35 · Angwin, CAThe pilot's exceedance of the airplane’s critical angle of attack during an aborted landing after an unstabilized approach and hard landing, which resulted in an aerodynamic stall and impact with trees and terrain. Contributing to the accident was the pilot’s…Jul 16, 2021 · N112TW · DestroyedNTSB ERA21LA292Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Princeton, KYThe pilot’s inadequate preflight planning in that he failed to accurately determine the takeoff weight of the helicopter, which resulted in exceeding the helicopter’s maximum weight capability.Jul 16, 2021 · N512RT · Substantial damageNTSB CEN21LA323Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Refugio, TXThe pilot’s failure to maintain directional control during the landing roll with a tailwind.Jul 16, 2021 · N174R · Substantial damageNTSB ANC21LA061Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Skwentna, AKA partial loss of engine power due to detonation/preignition damage to the No. 2 cylinder. The reason for the detonation/preignition damage could not be determined based on the available evidence.Jul 16, 2021 · N7137T · Substantial damageNTSB ANC21LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Skwentna, AKThe pilot’s use of excessive braking which resulted in a nose-over.Jul 16, 2021 · N99640 · Substantial damageNTSB WPR21FA272Accident · 4 fatalClass 3 · FieldFinal reportMooney M20J · Dinsmore, CAThe airplane’s degraded engine performance due to wear to the intake cam lobes, which diminished the airplane’s takeoff and climb performance, resulting in a subsequent collision with trees.Jul 15, 2021 · N4474H · DestroyedNTSB ERA21LA329Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASW 27-18 · Sterling, MAThe pilot’s failure to maintain the glider’s stability in the roll axis during the takeoff roll, which resulted in a dragged wingtip and ground loop.Jul 15, 2021 · N129MG · Substantial damageNTSB ERA21LA290Accident · 1 fatalClass 3 · LimitedFinal reportCameron 0-105 · Piermont, NHThe balloon pilot’s delay in relighting the burner, which resulted in a hard landing and his ejection from the balloon.Jul 15, 2021 · N2925L · Substantial damageNTSB ERA21LA289Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-23 · Easton, MDA total loss of left engine power and uncommanded feathering of the left propeller for reasons that could not be determined.Jul 15, 2021 · N776MC · Substantial damageNTSB ERA21LA288Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland Canada DHC-1 Chipmunk X · Lebanon, TNA total loss of engine power during the initial climb for reasons that could not be determined based on the available evidence.Jul 15, 2021 · N47YC · Substantial damageNTSB CEN21LA324Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Rhinelander, WIThe pilot’s failure to maintain directional control during landing.Jul 15, 2021 · N84318 · Substantial damageNTSB CEN21FA320Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Muscatine, IAThe noninstrument-rated pilot’s continued visual flight under a thunderstorm, where he encountered reduced visibility due to heavy precipitation, resulting in a loss of control due to spatial disorientation.Jul 14, 2021 · N2801T · DestroyedNTSB ERA21LA291Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A150K · Brooksville, FLA total loss of engine power as a result of carburetor icing.Jul 13, 2021 · N8412M · Substantial damageNTSB CEN21LA319Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-401 · Carroll, IAThe wear-related failure of the airframe fuel boost pump, which resulted in fuel starvation and a loss of engine power.Jul 13, 2021 · N7315P · Substantial damageNTSB CEN21FA314Accident · 1 fatalClass 3 · FieldFinal reportPZL Mielec M18 · Seiling, OKThe pilot’s in-flight loss of control due to the structural failure of a wing fitting and separation of the outboard wing section. Also causal were the inadequate wing fitting inspections, which failed to detect the initial corrosion and crack before it…Jul 12, 2021 · N9310R · DestroyedNTSB WPR21LA267Accident · No injuriesClass 4 · LimitedFinal reportJust JA30 Superstol · May, IDThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground-loop and collision with terrain.Jul 11, 2021 · N17VP · Substantial damageNTSB ERA21LA284Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Elba, ALThe partial loss of engine power due to the formation of carburetor ice, which resulted in reduced climb capability and impact with trees during takeoff.Jul 11, 2021 · N8172S · Substantial damageNTSB CEN21LA316Accident · No injuriesClass 3 · LimitedFinal reportCessna 172F · Eagle Butte, SDA total loss of engine power due to the fatigue failure of the No. 6 connecting rod.Jul 11, 2021 · N5340R · Substantial damageNTSB CEN21LA313Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT802 · Newell, IAThe pilot’s failure to maintain adequate clearance from crops during an agricultural flight.Jul 11, 2021 · N949TM · Substantial damageNTSB WPR21LA287Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36TC · Chandler, AZThe pilot’s delayed decision to abort the takeoff due to insufficient airspeed.Jul 10, 2021 · N222HC · Substantial damageNTSB WPR21LA269Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Petaluma, CAThe pilot’s improper landing flare which resulted in a hard landing following a partial loss of electrical power. Contributing to the accident was the pilot’s distraction and hampered visual function.Jul 10, 2021 · N996RA · Substantial damageNTSB WPR21FA266Accident · 2 fatalClass 3 · FieldFinal reportBeech C90 · Wikieup, AZThe failure and separation of the left wing’s outboard section due to a fatigue crack in the lower spar cap. Contributing to the accident was the operator’s decision to repair the wing spar instead of replacing it as recommended by the aircraft manufacturer.…Jul 10, 2021 · N3688P · DestroyedNTSB WPR21FA265Accident · 2 fatalClass 3 · FieldFinal reportNorth Wing Mustang · Albany, ORThe noncertificated pilot’s loss of aircraft control after a low-level turn with a bank angle that exceeded the manufacturer’s operating limitations.Jul 10, 2021 · UNREG · Substantial damageNTSB ERA21LA283Accident · 1 fatalClass 3 · LimitedFinal reportBailey N Moyes Dragonfly · Charlestown, NHThe passenger’s decision to continue an unstable approach while at low altitude and in proximity to a known obstacle, which resulted in a collision with power lines.Jul 10, 2021 · N346FL · Substantial damageNTSB CEN21LA315Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421C · Longmont, COThe loss of performance for reasons that could not be determined.Jul 10, 2021 · N66NC · Substantial damageNTSB WPR21LA285Accident · No injuriesClass 4 · LimitedFinal reportCessna T210 · Missoula, MTThe pilot's failure to extend the landing gear during landing. Contributing to the accident was the pilot’s failure to use a pre-landing checklist.Jul 9, 2021 · N6856R · Substantial damageNTSB CEN21LA432Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Berlin, ILThe pilot’s failure to maintain control of the helicopter with a stuck skid, which resulted in a dynamic rollover.Jul 9, 2021 · N170AM · Substantial damageNTSB WPR21LA274Accident · No injuriesClass 4 · LimitedFinal reportScott Mills CCX-2000 · Independence, ORThe pilot's loss of directional control while landing, which resulted in a runaway excursion and subsequent ground loop.Jul 7, 2021 · N536SJ · Substantial damageNTSB WPR21LA268Accident · No injuriesClass 3 · LimitedFinal reportBell 212HP · Weed, CAThe pilot’s failure to maintain altitude during an approach to a lake. Contributing to the accident was the pilot’s failure to release the full water bucket as the helicopter was settling, which reduced the helicopter’s out-of-ground-effect performance.Jul 7, 2021 · N911KW · Substantial damageNTSB ERA21LA285Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Greensboro, NCThe student pilot’s improper flare which resulted in abnormal ground contact and loss of control.Jul 7, 2021 · N91W · Substantial damageNTSB ERA21LA280Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Bishopville, SCThe flight instructor’s inadequate supervision of the student during a go-around, which resulted in a loss of lift and a subsequent collision with the VASI lights.Jul 7, 2021 · N1592J · Substantial damageNTSB CEN21LA311Accident · Minor injuriesClass 4 · LimitedFinal reportEslinger C W/Eslinger S M Cassutt · Pryor, OKThe pilot’s high flare and failure to execute a go-around which resulted in a hard landing and runway excursion.Jul 7, 2021 · N8277S · Substantial damageNTSB WPR21LA367Accident · No injuriesClass 4 · LimitedFinal reportQuest Kodiak 100 · Roche Harbor, WAThe pilot’s failure to maintain bank control during the landing roll which resulted in the right wing impacting the water’s surface.Jul 6, 2021 · N456SB · Substantial damageNTSB ERA21LA287Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46-500TP · Manteo, NCThe improperly secured pneumatic compressor discharge air (P3) line coupling nut on the engine, which ultimately allowed the nut to back off resulting in a partial loss of engine power.Jul 6, 2021 · N31062 · Substantial damageNTSB ERA21LA279Accident · No injuriesClass 4 · LimitedFinal reportTextron T206 · Statesville, NCThe pilot’s failure to maintain directional control while landing, which resulted in a runway excursion and collision with terrain.Jul 6, 2021 · N302WD · Substantial damageNTSB CEN21LA318Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Nappanee, INThe pilot’s failure to maintain clearance from the tower during low-level agricultural operations.Jul 6, 2021 · N602RE · Substantial damageNTSB CEN21LA309Accident · No injuriesClass 3 · LimitedFinal reportTitan T-51D · Ashtabula, OHThe tripped engine control computer circuit breaker caused by an excessive electrical load on the system, which resulted in a complete loss of engine power during the initial climb.Jul 6, 2021 · N15180 · Substantial damage