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 WPR20CA185Accident · No injuriesClass 4 · Data collectionFinal reportVans RV 6 · Clovis, NMThe pilot's improper landing flare which resulted in a hard, bounced landing, and subsequent runway excursion. Contributing to the accident was the airplane’s aft center of gravity at the time of the accident.Jun 17, 2020 · N1407W · Substantial damageNTSB ERA20LA219Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · McAlpin, FLThe pilot’s failure to abort the takeoff after recognizing poor airplane acceleration, the reason for which could not be determined based on available evidence. Contributing to the accident was the pilot’s likely inadvertent initiation of the takeoff with the…Jun 17, 2020 · N25449 · Substantial damageNTSB CEN20LA234Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT402 · Pine Bluff, ARThe pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and a loss of airplane control. Contributing was a partial loss of engine power for undetermined reasons.Jun 17, 2020 · N1532H · Substantial damageNTSB CEN20CA235Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CCX-2000-0086 · Gypsom, COThe pilot's failure to maintain airplane control during landing in gusting wind conditions.Jun 17, 2020 · N339KT · Substantial damageNTSB ANC20CA061Accident · No injuriesClass 4 · Data collectionFinal reportBeech A36 · Chignik Lagoon, AKThe pilot's improper approach, which resulted in a long landing and a runway overrun.Jun 17, 2020 · N777AK · Substantial damageNTSB WPR20CA184Accident · No injuriesClass 4 · Data collectionFinal reportCessna P210 · Maricopa, AZThe pilot's failure to extend the airplane’s retractable landing gear before landing.Jun 16, 2020 · N117KP · Substantial damageNTSB ERA20LA217Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT502 · Atmore, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall, spin, and loss of control.Jun 16, 2020 · N879JA · Substantial damageNTSB CEN20CA232Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA46 · Ely, MNThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapse during a gusty landing.Jun 16, 2020 · N27RZ · Substantial damageNTSB CEN20CA230Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R22 · El Campo, TXThe pilot's failure to maintain adequate clearance from the rice vegetation, which resulted in the helicopter's impact with terrain.Jun 16, 2020 · N797SH · Substantial damageNTSB WPR20CA183Accident · No injuriesClass 4 · Data collectionFinal reportCessna 310 · Butte, MTThe pilot's failure to maintain clearance from a fence post during final approach which resulted in a damage to the left main landing gear, and its subsequent collapse during landing.Jun 15, 2020 · N87395 · Substantial damageNTSB ERA20LA230Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Williston, FLThe pilot’s failure to maintain directional control while landing with a crosswind, which resulted in a runway excursion and nose landing gear collapse.Jun 15, 2020 · N117PR · Substantial damageNTSB ERA20LA216Accident · No injuriesClass 3 · LimitedFinal reportBell 47G · Atoka, TNA total loss of engine power due to a blocked fuel line; the reason for the blockage could not be determined based on the available evidence.Jun 15, 2020 · N473TT · Substantial damageNTSB ANC20LA060Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Fairbanks, AKThe pilot’s failure to utilize carburetor heat while flying in conditions conducive carburetor to icing, which resulted in a total loss of engine power.Jun 15, 2020 · N3186D · Substantial damageNTSB WPR20CA188Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 177RG · Lynden, WAThe pilot's failure to maintain control of the airplane during the landing approach, which resulted in the airplane exceeding its critical angle of attack, an aerodynamic stall, hard landing, and a landing gear collapse.Jun 14, 2020 · N1958Q · Substantial damageNTSB ERA20CA215Accident · No injuriesClass 4 · Data collectionFinal reportPipistrel Pipistrel Sinus 912 · Brookline, NHThe pilot's failure to maintain airspeed while landing with a quartering tailwind, which resulted in a loss of control and a hard landing.Jun 13, 2020 · N783TH · Substantial damageNTSB ERA20CA214Accident · No injuriesClass 4 · Data collectionFinal reportWaco YMF F5C · Ghent, NYA loss of directional control on takeoff, which resulted in a runway excursion and collision with trees.Jun 13, 2020 · N323TX · Substantial damageNTSB CEN20LA228Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 24 · Livingston, TXThe total loss of engine power due to the failure of the No. 3 cylinder for reasons that could not be determined based on available evidence.Jun 13, 2020 · N444JR · Substantial damageNTSB WPR20LA180Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7KCAB · Renton, WAMaintenance personnel’s inadequate post-maintenance inspections that resulted in the total loss of engine power due to a blockage in the air intake.Jun 12, 2020 · N36339 · Substantial damageNTSB CEN20CA257Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Reedsburg, WIThe student pilot's improper landing flare, which resulted a hard, bounced landing.Jun 12, 2020 · N738VY · Substantial damageNTSB CEN20CA241Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Bowling Green, MOThe pilot's improper flare, which resulted in a hard, bounced landing.Jun 12, 2020 · N65773 · Substantial damageNTSB CEN20CA229Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna T188 · McCurtain, OKThe pilot's failure to maintain the proper airspeed during a low altitude aerial application maneuver and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodymanic stall at too low of an altiutde to recover.Jun 12, 2020 · N2085J · Substantial damageNTSB ERA20LA212Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA32RT · Selma, ALThe mechanic’s failure to clean the oil suction screen during the most recent maintenance, which resulted in oil starvation and subsequent total loss of engine power.Jun 10, 2020 · N543GS · DestroyedNTSB WPR20LA176Accident · 1 fatalClass 3 · LimitedFinal reportVans RV4 · Safford, AZA loss of pitch control during the landing approach due to a jammed elevator control system.Jun 9, 2020 · N173CW · Substantial damageNTSB WPR20CA178Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Santa Barbara, CAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with a fence.Jun 9, 2020 · N75989 · Substantial damageNTSB CEN20CA225Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Aitkin, MNThe flight instructor's delayed remedial action, which resulted in a hard landing and loss of directional control while landing with a crosswind.Jun 9, 2020 · N2681D · Substantial damageNTSB WPR20CA209Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Lubbock, TXThe pilot's improper approach and descent rate, which resulted in a hard landing.Jun 8, 2020 · N92356 · Substantial damageNTSB ERA20CA210Accident · No injuriesClass 4 · Data collectionFinal reportGreat Lakes 2T 1A · St. Mary's, PAThe pilot's failure to maintain proper glide path during final approach which resulted in a collision with airport equipment short of the runway.Jun 8, 2020 · N863K · Substantial damageNTSB CEN20LA219Accident · 1 fatalClass 3 · LimitedFinal reportFlight Design Ctls · Beecher, ILThe pilot’s decision to continue takeoff after a partial loss of engine power, and the pilot’s subsequent failure to control airplane pitch during a forced landing. Contributing to the accident was the partial loss of engine power for reasons that could not…Jun 8, 2020 · N257V · DestroyedNTSB CEN20CA222Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 15 · Lancaster, TXThe pilot's failure to maintain directional control during landing.Jun 8, 2020 · N4123H · Substantial damageNTSB CEN20CA221Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · Hiawatha, KSThe pilot’s decision to attempt the takeoff with a tailwind in high density altitude conditions.Jun 8, 2020 · N5092J · Substantial damageNTSB CEN20CA220Accident · Minor injuriesClass 4 · Data collectionFinal reportVans RV8 · Sulfer, LAA loss of directional control as a result of a fractured landing gear attach bracket.Jun 8, 2020 · N44LA · Substantial damageNTSB ANC20LA059Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 12 · Anchorage, AKThe fatigue fracture of the American Iron and Steel Institute (AISI) 1025 carbon steel rudder post, which resulted in structural failure of the rudder. Contributing to the fatigue failure was the post’s susceptibility to fatigue cracking under normal service…Jun 8, 2020 · N3188M · Substantial damageNTSB WPR20LA170Accident · 1 fatalClass 3 · LimitedFinal reportKitfox Kitfox · Lander, WYThe inexperienced pilot’s exceedance of the airplane’s critical angle-of-attack during a turn at high density altitude, which resulted in an accelerated stall and impact with water. Contributing to the accident was the pilot’s poor judgment to continue the…Jun 7, 2020 · N595KF · Substantial damageNTSB ERA20CA243Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Greenwood, SCThe pilot's failure to maintain adequate clearance from a parked airplane while taxiing. Contributing to the accident was the parked airplane's position over the double-yellow taxiway edge lines and into the taxiway object-free movement area.Jun 7, 2020 · N6958J · Substantial damageNTSB ERA20CA209Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA38 · Cumberland, MDThe pilot's failure to maintain directional control during landing and the subsequent go-around in gusting crosswind conditions.Jun 7, 2020 · N2470D · Substantial damageNTSB CEN20LA216Accident · No injuriesClass 3 · LimitedFinal reportTeam 1600R · Marshall, MIMaintenance personnel’s improper installation of an improperly sized clamp on the fuel supply line, which allowed air to enter the supply line, a subsequent loss of engine power, and a forced landing.Jun 7, 2020 · N827WS · Substantial damageNTSB CEN20CA226Accident · No injuriesClass 4 · Data collectionFinal reportBellanca 17 30 · Talihina, OKThe pilot's failure to maintain control of the airplane during a crosswind landing, which resulted in a hard landing and runway excursion.Jun 7, 2020 · N6681V · Substantial damageNTSB CEN20CA217Accident · Minor injuriesClass 4 · Data collectionFinal reportAirborne XT912 · Bristol, WIThe pilot's incorrect flight control input during the landing flare, which resulted in an impact with the ground.Jun 7, 2020 · N88ZT · Substantial damageNTSB CEN20LA214Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172 · New Washington, INA high velocity descent and impact with terrain for undetermined reasons.Jun 6, 2020 · N13520 · DestroyedNTSB ANC20CA058Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 12 · Palmer, AKThe pilot’s improper decision to load the airplane beyond its allowable gross weight limits, which resulted in an impact with a tree and collision with terrain.Jun 6, 2020 · N3824M · Substantial damageNTSB WPR20LA252Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Salem, ORA fatigue failure of the right main landing gear trunnion.Jun 5, 2020 · N8244Y · Substantial damageNTSB WPR20LA169Accident · 3 fatalClass 3 · LimitedFinal reportCessna 175 · Redlands, CAThe noncertificated pilot’s visual flight rules flight into instrument meteorological conditions and subsequent impact with terrain.Jun 5, 2020 · N9217B · Substantial damageNTSB ERA20LA207Accident · 2 fatalClass 3 · LimitedFinal reportQuad City Challenger · Wurtsboro, NYA loss of control after takeoff due to the pilot’s improper use of ballast weight. Contributing was the pilot’s decision to operate the airplane above its maximum gross weight.Jun 5, 2020 · N850RW · Substantial damageNTSB WPR20LA175Accident · Minor injuriesClass 3 · LimitedFinal reportGrumman G164 · Lincoln, CAThe pilot’s loss of directional control on takeoff for undetermined reasons.Jun 4, 2020 · N8486K · Substantial damageNTSB WPR20CA168Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Yakima, WAThe pilot's failure to maintain directional control of the airplane during an aborted landing, which resulted in a ground loop, runway excursion, and subsequent nose over.Jun 4, 2020 · N87607 · Substantial damageNTSB CEN20LA211Accident · No injuriesClass 3 · LimitedFinal reportBeech 23 · Cleburne, TXThe total loss of engine power due to metal fatigue failure of the No. 1 cylinder wall.Jun 4, 2020 · N7941L · Substantial damageNTSB CEN20CA242Accident · No injuriesClass 4 · Data collectionFinal reportCessna 305 · Castroville, TXThe pilot's failure to maintain directional control during landing.Jun 4, 2020 · N88688 · Substantial damageNTSB CEN20CA212Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28R · Corpus Cristi, TXThe pilot's failure to utilze the emergency landing gear extension procedure after a short-circuit within the normal landing gear system, which resulted in a landing gear collapse during landing.Jun 4, 2020 · N533K · Substantial damageNTSB WPR20LA165Accident · No injuriesClass 3 · LimitedFinal reportOmf 100 · Glendale, AZMaintenance personnel’s failure to comply with the procedures of an airworthiness directive, which resulted in a fatigue failure of the longitudinal frame tube during landing and collapse of the right main landing gear.Jun 3, 2020 · N225CK · Substantial damageNTSB WPR20CA199Accident · No injuriesClass 4 · Data collectionFinal reportBeech D 45 · Ione, CAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and impact with terrain.Jun 3, 2020 · N341MR · Substantial damage