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 GAA16CA247Accident · No injuriesData collectionFinal reportCessna 182 · Redding, CAThe student pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and nose over.May 19, 2016 · N7610S · Substantial damageNTSB ERA16LA192Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Batavia, NYThe student pilot's failure to maintain directional control during takeoff, which resulted in a collision with runway signs.May 19, 2016 · N7781W · Substantial damageNTSB ERA16FA188Accident · 1 fatalField investigationFinal reportBeech D35 · Sevierville, TNThe pilot's failure to properly configure the landing gear and the pilot's inappropriate decision to abort the landing after the propeller had contacted the runway, which resulted in a loss of thrust and a subsequent loss of control of the airplane.May 19, 2016 · N2967B · Substantial damageNTSB CEN16LA196Accident · Serious injuriesLimited investigationFinal reportWaco Classic YMF · West Des Moines, IAThe pilot's mismanagement of the airplane's fuel supply, which resulted in a total loss of engine power due to fuel starvation.May 19, 2016 · N56ED · Substantial damageNTSB WPR16FA112Accident · 2 fatalField investigationFinal reportNorth American AT 6 · Mesa, AZThe pilot's inability to return to the departure airport due to an unspecified in-flight emergency for reasons that could not be determined during a postaccident examination of the airplane.May 18, 2016 · N3198G · DestroyedNTSB GAA16CA245Accident · No injuriesData collectionFinal reportCessna 172 · Carbondale, ILThe student pilot's inadequate flare which resulted in a hard landing, loss of directional control, and a runway excursion.May 18, 2016 · N4668G · Substantial damageNTSB CEN16TA194Accident · No injuriesFinal reportNorth American AT6 · Mason, MIThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion and impact with a ditch.May 18, 2016 · N757LF · Substantial damageNTSB CEN16FA188Accident · 1 fatalField investigationFinal reportCessna P210N · Sheridan Lake, COThe pilot's severe impairment from the combined effects of high levels of ingested alcohol as well as three impairing medications (zolpidem, lorazepam, and diphenhydramine), which resulted in his decision to attempt an aerobatic maneuver that the airplane was…May 18, 2016 · N6609P · Substantial damageNTSB GAA16CA242Accident · Minor injuriesData collectionFinal reportVan B Anthony Zodiac · Grass Valley, CAThe pilot's failure to maintain a stabilized approach and landing, which resulted in a hard landing, loss of directional control, runway excursion, and collision with a parked airplane.May 17, 2016 · N99SZ · DestroyedNTSB ERA16LA190Accident · No injuriesLimited investigationFinal reportCessna R182 · Lake City, FLInternal failure of the main electrical contactor, which resulted in a complete loss of electrical power and an inability to extend the landing gear through normal means.May 16, 2016 · N9077C · Substantial damageNTSB ERA16FA186Accident · Serious injuriesField investigationFinal reportPiper PA28 · Homestead, FLThe pilot's improper decision to allow the passenger to attempt a landing, which resulted in a loss of control during landing with a quartering tailwind. Contributing to the severity of the pilot's injuries was the separation of the deteriorated shoulder…May 16, 2016 · N7031R · Substantial damageNTSB ERA16FA185Accident · 4 fatalField investigationFinal reportBeech A36TC · Tupelo, MSA preexisting stress rupture that initiated at a spot weld in the turbocharger v-band exhaust clamp, which resulted in the failure of the clamp and separation of the exhaust tailpipe, an in-flight fire, and subsequent impact with terrain.May 16, 2016 · N60RW · DestroyedNTSB CEN16LA192Accident · No injuriesLimited investigationFinal reportCessna T206H · New Roads, LAThe pilot’s failure to maintain directional control during the landing roll.May 16, 2016 · N80TK · Substantial damageNTSB WPR16FA111Accident · 1 fatalField investigationFinal reportCessna R182 · Altadena, CAThe pilot's failure to maintain clearance from rising mountainous terrain while flying in instrument meteorological conditions. Contributing to the accident was the loss of radio communications for a reason that could not be determined because of the…May 15, 2016 · N133BW · DestroyedNTSB GAA16CA244Accident · Minor injuriesData collectionFinal reportSchleicher ASW 19 · Frankton, INThe pilot's exceedance of the critical angle of attack on final approach in turbulent conditions, which resulted in an aerodynamic stall and collision with terrain.May 15, 2016 · N19VT · Substantial damageNTSB GAA16CA234Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Pahokee, FLThe pilot's failure to maintain directional control and lateral bank control during the aborted landing, which resulted in collision with terrain.May 15, 2016 · N463C · Substantial damageNTSB GAA16CA233Accident · No injuriesData collectionFinal reportCessna 180 · St. George, UTThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, ground loop, right main landing gear collapse, and substantial damage to the right wing.May 15, 2016 · C-GBLK · Substantial damageNTSB CEN16LA186Accident · No injuriesLimited investigationFinal reportPiper PA 32R · Alpine, TXThe engine’s decreased performance due to high-density altitude conditions and a partially obstructed fuel injector nozzle. Contributing to the pilot's decision to perform an off-field landing was the anomalous high exhaust gas temperature reading.May 15, 2016 · N185DX · Substantial damageNTSB WPR16LA113Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Delano, CAThe student pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.May 14, 2016 · N3724Y · Substantial damageNTSB GAA16CA256Accident · No injuriesData collectionFinal reportCirrus Design SR20 · South St Paul, MNThe pilot's excessive nose high pitch attitude, which resulted in a tail strike during the landing flare.May 14, 2016 · N323FT · Substantial damageNTSB GAA16CA240Accident · No injuriesData collectionFinal reportMills Gregory T AIR Commander LRT · Tybee Island, GAThe pilot's decision to perform a touch-and-go on unsuitable terrain, which resulted in a loss of directional control and a rollover.May 14, 2016 · N962GT · Substantial damageNTSB GAA16CA235Accident · No injuriesData collectionFinal reportCessna 182P · Williamsburg, VAThe pilot's failure to maintain directional control during the landing in variable direction and gusting wind conditions, resulting in a landing off the side of the runway and impact with a drainage culvert.May 14, 2016 · N58625 · Substantial damageNTSB ERA16FA182Accident · 1 fatalField investigationFinal reportGreg Connell Pitts S-2SW · Atlanta, GAThe pilot's failure to maintain proper positioning during performance of an aerobatic maneuver and his subsequent failure to discontinue maneuvering when unable to reestablish proper positioning during a steep descent toward the ground.May 14, 2016 · N24CD · DestroyedNTSB CEN16LA181Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502 · West, TXThe pilot’s failure to see and avoid cellular tower guy wires. Contributing to the accident was the pilot’s decision to operate at low altitude.May 14, 2016 · N1546Z · DestroyedNTSB ANC16CA027Accident · No injuriesData collectionFinal reportCessna 180 · Wasilla, AKThe pilot's failure to maintain directional control during landing, which resulted in a collision with terrain. Contributing to the accident was the loose dirt and gravel deposited in the center of the runway.May 14, 2016 · N2423F · Substantial damageNTSB WPR16LA109Accident · No injuriesLimited investigationFinal reportCessna 172RG · Las Vegas, NVThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion.May 13, 2016 · N6281V · Substantial damageNTSB WPR16LA108Accident · Minor injuriesLimited investigationFinal reportCessna 180 · California City, CAA directional upset on landing due to a thermally induced atmospheric disturbance, which the pilot was unable to successfully counter due to improperly set rudder travel limits.May 13, 2016 · N9370C · Substantial damageNTSB GAA16CA243Accident · No injuriesData collectionFinal reportPiper PA-28 · Crystal River, FLThe student pilot's failure to maintain directional control during the takeoff, which resulted in runway excursion and collision with a ditch. Contributing to the accident was the improper flap retraction procedure employed by the pilot during takeoff.May 13, 2016 · N991A · Substantial damageNTSB GAA16CA238Accident · No injuriesData collectionFinal reportWaco YKS 7 · Millersburg, OHThe pilot's loss of directional control during landing in gusting wind conditions resulting in excessive brake application, and airplane nose over.May 13, 2016 · N17734 · Substantial damageNTSB CEN16LA200Accident · No injuriesLimited investigationFinal reportMooney M20 · Little Rock, ARA loss of engine power due to water contamination of the fuel.May 13, 2016 · N6371Q · Substantial damageNTSB CEN16LA185Accident · No injuriesLimited investigationFinal reportJewett Brandon RV 6 · McKinney, TXThe pilot’s loss of directional control during takeoff.May 13, 2016 · N700MJ · Substantial damageNTSB WPR16LA107Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Acampo, CAA total loss of engine power due to a fatigue fracture of the fuel pressure line that connected the fuel control unit and the fuel flow transducer due to vibration as the result of a fatigue fracture of an associated support clamp. Contributing to the…May 12, 2016 · N1114A · Substantial damageNTSB GAA16CA236Accident · No injuriesData collectionFinal reportPiper PA 28R · Lee's Summit, MOThe pilot's improper pitch control after the landing flare, resulting in an aerodynamic stall, hard landing, and consequent substantial left wing damage.May 12, 2016 · N228NC · Substantial damageNTSB GAA16CA232Accident · No injuriesData collectionFinal reportPiper PA 12 · Simsbury, CTThe pilot's failure to attain the proper touchdown point and the airplane's subsequent impact with a fence during an attempted aborted landing.May 11, 2016 · N3506M · Substantial damageNTSB GAA16CA230Accident · Minor injuriesData collectionFinal reportGrenier Raymond Vans Aircraft · Keene, NHThe airplane striking a deer during the landing roll, resulting in a loss of directional control, runway excursion, and subsequent nose over.May 11, 2016 · N220RG · Substantial damageNTSB CEN16LA180Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Lyons Point, LAA total loss of engine power due to debris contamination of the fuel system. Contributing to the accident was the pilot's inadequate preflight inspection.May 11, 2016 · N8362K · Substantial damageNTSB WPR16LA105Accident · Minor injuriesLimited investigationFinal reportBeech B24R · Groveland, CAThe pilot's decision to conduct an upslope, downwind takeoff combined with an improper flap setting, which resulted in the airplane's inability to clear trees beyond the runway end. The reason for the improper flap setting could not be determined.May 10, 2016 · N2052L · Substantial damageNTSB CEN16LA187Accident · No injuriesLimited investigationFinal reportBeech B100 · Dexter, MOA collapse of the right main landing gear for reasons that could not be determined because of the damage to the landing gear system.May 10, 2016 · N86TR · Substantial damageNTSB CEN16LA178Accident · No injuriesLimited investigationFinal reportMooney M20K · Akron, OHA missing bolt in the nose landing gear assembly, which resulted in the airplane suddenly turning left and the pilot's inability to maintain directional control during a crosswind takeoff.May 10, 2016 · N57535 · Substantial damageNTSB GAA16CA227Accident · Minor injuriesData collectionFinal reportAmerican Champion 8GCBC · Plainview, TXThe pilot's failure to maintain directional control during gusty wind conditions. Contributing to the outcome was the pilot's exceedance of the maximum crosswind component during takeoff.May 9, 2016 · N326JH · Substantial damageNTSB WPR16FA103Accident · Serious injuriesField investigationFinal reportPiper PA28 · Pomona, CAThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.May 8, 2016 · N5046W · Substantial damageNTSB GAA16CA224Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Oberlin, KSThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, and a ground loop.May 8, 2016 · N6181Q · Substantial damageNTSB WPR16LA104Accident · No injuriesLimited investigationFinal reportBell UH 1B · Maxwell, CAA reduction in available engine power during takeoff due to a stuck hot air valve, which resulted in low rotor rpm and a forced landing. Contributing to the accident was the lack of dry film lubricant and the presence of corrosion on the hot air valve…May 7, 2016 · N486SA · Substantial damageNTSB WPR16FA102Accident · 1 fatalField investigationFinal reportBeech G35 · Surprise, AZThe mechanic's failure to properly secure the bolt connecting the throttle cable to the carburetor during the installation of the carburetor, which resulted in a loss of engine power.May 7, 2016 · N4401D · Substantial damageNTSB GAA16CA229Accident · No injuriesData collectionFinal reportWaco Classic YMF · Pace, FLThe pilot's failure to maintain directional control during the takeoff roll, and his excessive pitch attitude at low airspeed during initial climb, resulting in an aerodynamic stall and consequent ground impact.May 7, 2016 · N119SW · Substantial damageNTSB GAA16CA228Accident · No injuriesData collectionFinal reportBeech C23 · Yucca Valley, CAThe pilot's failure to attain airspeed and a positive rate of climb during takeoff in gusty wind conditions, resulting in a loss of directional control, an uncontrolled descent and collision with terrain.May 7, 2016 · N6566R · Substantial damageNTSB GAA16CA226Accident · No injuriesData collectionFinal reportCessna TR182 · Bloomington, INThe pilot's failure to maintain the airplane's descent rate resulting in a hard landing, and subsequent substantial damage to the firewall.May 7, 2016 · N9281R · Substantial damageNTSB ERA16LA179Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12 D · Critz, VAThe pilot’s failure to maintain airspeed while on final approach, which resulted in an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.May 7, 2016 · N43363 · Substantial damageNTSB ANC16FA023Accident · 1 fatalField investigationFinal reportAirbus AS350 · Skagway, AKThe pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in the pilot experiencing a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident were the…May 7, 2016 · N94TH · Substantial damageNTSB WPR16LA101Accident · No injuriesLimited investigationFinal reportAntonov AN2 · San Bernardino, CAThe mechanic’s failure to inspect the fine fuel filter gascolator as required during the most recent inspection, which resulted in a total loss of engine power due to fuel contamination.May 6, 2016 · N2AN · Substantial damage