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 ERA21LA226Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Lincoln Park, NJThe pilot's loss of directional control during an aborted landing in crosswind conditions.May 23, 2021 · N16528 · Substantial damageNTSB CEN21FA230Accident · 1 fatalClass 3 · FieldFinal reportSub-Sonex JSX-2 · Shreveport, LAThe pilot’s failure to maintain clearance with the water while performing aerobatics, resulting in the airplane’s impact into a lake. Contributing was the pilot’s decision to perform aerobatics at low altitude.May 23, 2021 · N465JC · DestroyedNTSB ERA21FA225Accident · 2 fatalClass 3 · FieldFinal reportFlight Design Ctsw · Winterville, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall and a loss of control.May 22, 2021 · N708JM · DestroyedNTSB CEN21LA244Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland DHC-2 MK.I · Oak Island, MNThe failure of an O-ring in the landing gear system, which resulted in the inadvertent extension of the main wheel in the amphibious float. Contributing to the accident was the pilot’s decision to depart with a known hydraulic leak in the landing gear system.May 22, 2021 · N218RD · Minor damageNTSB CEN21LA235Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · McAllen, TXThe student pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with a runway sign.May 22, 2021 · N999MA · Substantial damageNTSB WPR21LA207Accident · No injuriesClass 4 · LimitedFinal reportCessna TU206 · Phoenix, AZThe pilot's failure to maintain directional control after an encounter with a windshear during the landing roll, which resulted in a runway excursion.May 21, 2021 · XBBLB · Substantial damageNTSB ERA21FA224Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-31P · Myrtle Beach, SCThe mechanic’s inadvertent installation of the elevator trim tabs in reverse, which resulted in the pitch trim system operating opposite of the pilot’s input and the pilot’s subsequent loss of control.May 21, 2021 · N575BC · DestroyedNTSB WPR21LA204Accident · Serious injuriesClass 3 · LimitedFinal reportMcclure B J Glasair III · Eugene, ORThe pilot’s loss of airplane control during the approach to landing due to an asymmetrical flap deployment for reasons that could not be determined based on the available evidence.May 20, 2021 · N54CB · DestroyedNTSB ERA21LA266Accident · Minor injuriesClass 4 · LimitedFinal reportPilatus B4-PC11 · Sterling, MAThe pilot’s misjudged approach angle which resulted in impact with trees and terrain.May 20, 2021 · N65317 · Substantial damageNTSB ERA21LA228Accident · Minor injuriesClass 4 · LimitedFinal reportRobert Trembly JA20 Highlander · Central City, KYThe pilot’s failure to properly secure the left wing fuel cap before flight, which resulted in a loss of engine power due to fuel exhaustion.May 20, 2021 · N743BT · Substantial damageNTSB ERA21LA222Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20K · Dawson, GAMaintenance personnel’s failure to properly secure the No. 4 connecting rod bolt nut with a cotter pin, resulting in a total loss of engine power.May 20, 2021 · N9514R · Substantial damageNTSB CEN21LA229Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Washington Court House, OHThe pilot's failure to maintain directional control during a soft field takeoff.May 20, 2021 · N15033 · Substantial damageNTSB ERA21LA268Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210 · Bloomsburg, PAThe pilot’s unstable approach and delayed go-around attempt, which resulted in a porpoised landing, a nose landing gear collapse, and runway excursion.May 19, 2021 · N7568N · Substantial damageNTSB WPR21LA202Accident · No injuriesClass 4 · LimitedFinal reportGoodsell Lynn A Classic 4 · Richmond, UTThe pilot’s failure to maintain clearance from powerlines while maneuvering for landing, which resulted in a wire strike and impact with terrain.May 18, 2021 · N549Z · Substantial damageNTSB WPR21LA199Accident · Minor injuriesClass 4 · LimitedFinal reportHarry Crosby RV-6 · Byron, CAThe pilot’s failure to maintain directional control of the airplane during takeoff while operating in gusting wind conditions, which resulted in a runway excursion and subsequent collision with terrain.May 18, 2021 · N16CX · Substantial damageNTSB CEN21LA223Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-502A · Clayton, LAThe pilot’s loss of airplane control resulting in an aerodynamic stall while executing a steep turnaround during an aerial application flight.May 18, 2021 · N887LA · Substantial damageNTSB CEN21LA222Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Racine, WIThe fatigue failure of the carburetor throttle control cable, which resulted in a partial loss of engine control.May 18, 2021 · N521CT · DestroyedNTSB WPR21LA197Accident · No injuriesClass 4 · LimitedFinal reportStearman 4E · Porterville, CAThe pilot’s loss of directional control while landing, which resulted in a landing gear collapse.May 17, 2021 · N663K · Substantial damageNTSB CEN21LA228Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Pinecreek, MNThe pilot’s failure to maintain control of the airplane in gusting crosswind conditions.May 17, 2021 · N416RP · Substantial damageNTSB WPR21LA198Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Paris, IDThe pilot's improper flare which resulted in a bounced landing, loss of directional control and collision with terrain.May 16, 2021 · N321PF · Substantial damageNTSB CEN21LA232Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Whitewater, WIAn inflight instrument malfunction for reasons that could not be determined based on available information, which led to the pilot’s decision to activate the airframe parachute system.May 16, 2021 · N4144B · Substantial damageNTSB CEN21LA226Accident · Serious injuriesClass 4 · LimitedFinal reportI.C.A.-Brasov IS-28B2 · Hampshire, ILThe flight instructor’s failure to maintain aircraft control resulting in the exceedance of the glider’s critical angle of attack following the breakage of the weak/safety link during a winch launch, which resulted in an aerodynamic stall and spin, and…May 16, 2021 · N41CR · Substantial damageNTSB WPR21LA196Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Wallowa, ORThe pilots failure to maintain airplane control during the landing roll after experiencing a tailwind gust which required excessive braking and resulted in the airplane nosing over.May 15, 2021 · N101BC · Substantial damageNTSB WPR21LA194Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 210 · Lake Arrowhead, CAA total loss of engine power due to a malfunction of the fuel flow manifold valve.May 15, 2021 · N7350E · Substantial damageNTSB ERA21LA223Accident · No injuriesClass 3 · LimitedFinal reportZenith Zodiac 601 XL · McKenzie, TNThe improper installation and inspection of the propeller, which resulted in an in-flight separation of the propeller assembly.May 15, 2021 · N493TG · Substantial damageNTSB ERA21LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Brewton, ALThe pilot’s failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with the ground.May 15, 2021 · N3396J · Substantial damageNTSB ERA21LA215Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Daytona Beach, FLBoth pilots’ failure to maintain control during the landing flare and the flight instructor’s failure to maintain control during an attempted go-around, in gusting quartering headwind conditions, which resulted in the exceedance of the airplane’s critical…May 14, 2021 · N62568 · Substantial damageNTSB CEN21LA221Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Pinckneyville, ILThe total loss of engine power due to oil starvation. The reason for the oil starvation could not be determined based on available evidence.May 14, 2021 · N1875W · Substantial damageNTSB ERA21LA216Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Gulf Shores, ALThe flight instructor’s delayed remedial action, which resulted in a loss of control during an attempted go-around.May 13, 2021 · N5170K · Substantial damageNTSB CEN21LA219Accident · Serious injuriesClass 3 · LimitedFinal reportBeech B24R · New Lenox, ILThe total loss of engine power due to fuel contamination as a result of the pilot’s improper fueling of the airplane.May 13, 2021 · N9199S · Substantial damageNTSB CEN21LA218Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Tulsa, OKThe pilot’s inability to extend the main landing gear due to incomplete maintenance, which resulted in a partial wheels-up landing and the mechanic’s failure to follow proper maintenance procedures that led to the loss of main landing gear system hydraulic…May 13, 2021 · N8051B · Substantial damageNTSB ANC21LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Palmer, AKThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of control and ground loop.May 13, 2021 · N154T · Substantial damageNTSB WPR21LA221Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2010 · Truckee, CAThe pilot’s improper flare during a landing attempt in crosswind conditions, which resulted in a bounced landing and impact with the ground.May 12, 2021 · N2010P · Substantial damageNTSB WPR21LA200Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164C · Glenn, CAThe pilot’s fuel mismanagement, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport hard landing.May 12, 2021 · N6596K · Substantial damageNTSB WPR21LA195Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Hillsboro, ORThe pilot’s delayed remediation following an aborted takeoff run, which resulted in a runway overrun and collision with trees.May 12, 2021 · N51LL · Substantial damageNTSB ERA21LA255Accident · No injuriesClass 4 · LimitedFinal reportPage Joseph E Vans RV-4 · Martinsburg, WVThe pilot’s improper landing flare in variable crosswind conditions, which resulted in a hard landing.May 12, 2021 · N54RV · Substantial damageNTSB ERA21LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Johnson City, TNThe student pilot’s excessive airspeed during the landing approach and his delayed remedial action, which resulted in the airplane striking obstacles during an aborted landing. Contributing was the pilot’s decision to land with a tailwind.May 12, 2021 · N6344E · Substantial damageNTSB CEN21LA227Accident · No injuriesClass 4 · LimitedFinal reportVarner David L Vans RV-8 · Watkins, COThe pilot’s failure to maintain control of the airplane during landing.May 12, 2021 · N51LV · Substantial damageNTSB CEN21LA217Accident · No injuriesClass 4 · LimitedFinal reportSmith Miniplane DSA-1 · Fulton, MOThe pilot’s failure to maintain control of the airplane during landing in gusty crosswinds.May 12, 2021 · N179VP · Substantial damageNTSB CEN21LA216Accident · No injuriesClass 3 · LimitedFinal reportAerospatiale AS350 B2 Ecureuil · Yukon, OKThe pilot receiving instruction’s untimely and unidentified inadvertent activation of the hydraulic cut-off switch, which turned off the hydraulic system while the helicopter was at slow airspeed followed by a rapid power increase, which resulted in a loss of…May 12, 2021 · N841BP · DestroyedNTSB CEN21FA215Accident · No injuriesClass 3 · FieldFinal reportSwearingen SA226TC · Englewood, COThe Cirrus pilot’s failure to maintain the final approach course for the assigned runway, which resulted in a collision with the Swearingen which was on final approach to the parallel runway. Contributing to the accident was the failure of the controller to…May 12, 2021 · N280KL · 2 aircraft · Substantial damageNTSB ANC21LA039Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Kenai, AKThe pilot's excessive application of the airplane’s wheel brakes while landing, which resulted in a nose over.May 12, 2021 · N92793 · Substantial damageNTSB WPR21LA190Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Coeur d' Alene, IDThe student pilot’s failure to maintain directional control during the landing roll, and the flight instructors delayed remedial action which resulted in a runway excursion and collision with terrain.May 11, 2021 · N7296K · Substantial damageNTSB CEN21LA213Accident · Minor injuriesClass 3 · LimitedFinal reportBeech C23 · Merrill, WIThe loss of engine power due to tappet failure.May 11, 2021 · N793Y · Substantial damageNTSB CEN21LA212Accident · No injuriesClass 4 · LimitedFinal reportRichards Heavylift Helo UH-1H · Norris City, ILThe pilot’s improper positioning of the helicopter on the landing pad, and his failure to monitor and control the helicopter as fuel and chemical product were loaded, which led to the helicopter tipping and sliding off the landing pad, and subsequently…May 10, 2021 · N567VF · Substantial damageNTSB ANC21LA040Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Gakona, AKThe pilot’s decision to initiate a flight with a failed mixture control cable which resulted in a total loss of engine power.May 10, 2021 · N5489H · Substantial damageNTSB WPR21LA187Accident · No injuriesClass 4 · LimitedFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Sacramento, CAThe pilot’s failure to maintain directional control during landing in gusty wind conditions which resulted in a runway excursion and collision with terrain.May 9, 2021 · N104GX · Substantial damageNTSB ANC21LA038Accident · No injuriesClass 3 · LimitedFinal reportEnstrom F-28F · Palmer, AKA loss of drive to the rotor system due to the disengagement of the main belt drive tensioning system, which resulted in a forced landing. The disengagement was due to inadequate clearance between the clutch handle and the roll pin in the handle bellcrank…May 9, 2021 · N8627J · Substantial damageNTSB WPR21LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · San Bernardino, CAThe pilot’s improper landing flare, which resulted in a hard landing and his subsequent inadequate pitch and airplane control during a go around which resulted in a nose landing gear collapse.May 8, 2021 · N54PW · Substantial damageNTSB WPR21LA186Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Tucson, AZThe student pilot’s improper pitch control and landing flare, which resulted in a hard bounce and subsequent porpoised landing.May 8, 2021 · N54140 · Substantial damage