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 CEN22LA205Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Auburn, INThe student pilot’s improper landing flare and the flight instructor’s delayed remedial response which resulted in an aerodynamic stall.May 19, 2022 · N2128E · Substantial damageNTSB CEN22LA204Accident · No injuriesClass 3 · LimitedFinal reportCessna T210N · Denver, COThe main landing gear collapsed during landing for reasons that could not be determined.May 17, 2022 · N210SD · Substantial damageNTSB CEN22FA203Accident · 1 fatalClass 3 · FieldFinal reportAmerican AA-1A · Cleburne, TXThe student pilot’s decision to operate the airplane after consuming alcohol, which led to an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and a subsequent loss of control at a low altitude.May 17, 2022 · N6409L · Substantial damageNTSB ANC22LA033Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft F19 · Anchorage, AKA loss of engine power for reasons that could not be determined due to a lack of available evidence.May 17, 2022 · N927AP · Substantial damageNTSB WPR22LA187Accident · Minor injuriesClass 4 · LimitedFinal reportTwenty Second Street Backcountry Boss · Douglas, WYThe pilot’s inadequate flare and subsequent loss of airplane control during landing.May 16, 2022 · N829PW · Substantial damageNTSB CEN22LA210Accident · No injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Angola, INThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard landing and the nose landing gear collapse.May 16, 2022 · N3530H · Substantial damageNTSB ERA22FA227Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS 2-33A · Blairstown, NJThe student pilot’s failure to maintain proper alignment with the landing area during the approach, which resulted in the left wing impacting a tree.May 15, 2022 · N17879 · Substantial damageNTSB WPR22LA183AccidentClass 4 · LimitedFinal reportPyka Pelican · Winters, CADelamination of the uncrewed aircraft systems’ right wing skin surfaces from the wing spar that resulted in a spin and impact with terrain.May 14, 2022 · N605PK · Substantial damageNTSB WPR22LA179Accident · No injuriesClass 4 · LimitedFinal reportSparks Ralph A RV8 · Deming, NMThe pilot’s loss of airplane control during takeoff following an encounter with a gust of wind.May 14, 2022 · N669RS · Substantial damageNTSB WPR22LA177Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-12 · Enterprise, ORThe inadequate maintenance and inspection of the crankshaft expansion plug, which resulted in the separation of the expansion plug from the crankshaft and the subsequent loss of oil and windshield obstruction during departure.May 14, 2022 · N3960M · Substantial damageNTSB ERA22LA230Accident · No injuriesClass 4 · LimitedFinal reportBeech C24 · Gallatin, TNA landing gear collapse due to the failure and/or separation of the pin in the right main landing gear.May 14, 2022 · N6016K · Substantial damageNTSB ERA22LA229Accident · No injuriesClass 3 · LimitedFinal reportMesserschmitt-Bolkow-Blohm BK 117 B-2 · Rochester, NYAn unintentional movement of the cyclic control before takeoff, which resulted the main rotor blades contacting the fixed wire cutter.May 14, 2022 · N370SS · Substantial damageNTSB ERA22LA228Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Lancaster, NYThe student pilot’s excessive pitch during takeoff resulted in a loss of control and impact with terrain. Contributing was the student’s failure to relinquish the controls when ordered by the instructor.May 14, 2022 · N20459 · Substantial damageNTSB ERA22FA226Accident · 1 fatalClass 3 · FieldFinal reportCessna 172H · Miami, FLA total loss of engine power due to carburetor ice as a result of the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.May 14, 2022 · N8845Z · Substantial damageNTSB ERA22LA225Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · Owensboro, KYThe pilot's failure to maintain directional control during takeoff.May 13, 2022 · N92913 · Substantial damageNTSB CEN22LA201Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Sport 2S · Osawatomie, KSThe loss of engine power due to fuel exhaustion and the pilot’s failure to maintain control of the airplane during a forced landing which resulted in an aerodynamic stall.May 13, 2022 · N202JC · Substantial damageNTSB CEN22LA199Accident · No injuriesClass 4 · LimitedFinal reportPiper J3F-65 · Port Bolivar, TXThe pilot’s failure to maintain directional control during takeoff.May 13, 2022 · N35257 · Substantial damageNTSB WPR22LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Franklin, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll.May 12, 2022 · N23FG · Substantial damageNTSB CEN22LA198Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Port Bolivar, TXThe pilot’s failure to attain a proper soft field takeoff pitch attitude during takeoff that resulted in a runway excursion and subsequent impact with a canal.May 12, 2022 · N9380G · Substantial damageNTSB WPR22LA174Accident · Serious injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 407 · Livermore, CALoss of engine power due to the pilot inadvertently selecting engine IDLE mode while in flight, which reduced rotor and engine speed to a level that could not sustain flight.May 11, 2022 · N999GH · Substantial damageNTSB ERA22LA224Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-301 · Somerville, TNThe inadequate inspection and maintenance of the engine exhaust system, which resulted in an in-flight fire.May 11, 2022 · N31580 · Substantial damageNTSB ERA22FA223Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-250 · Athens, GAA total loss of engine power for reasons that could not be determined based on the available information.May 11, 2022 · N8007P · DestroyedNTSB DCA22LA182Incident · No injuriesClass 3 · LimitedFinal reportMitsubishi CL-600-2B19 · Houston, TXA lateral runway excursion during landing for reasons that could not be determined based on the available evidence.May 11, 2022 · N965SW · Minor damageNTSB CEN22LA196Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Marshall, OKThe pilot’s failure to manage fuel, which resulted in a loss of engine power to both engines due to fuel starvation.May 11, 2022 · N29257 · Substantial damageNTSB WPR22LA176Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Tucson, AZThe pilot’s failure to maintain directional control during landing.May 10, 2022 · N1272A · Substantial damageNTSB CEN22LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Traverse City, MIThe failure of maintenance personnel to properly torque a fuel line “B” nut, which resulted in a total loss of engine power.May 10, 2022 · N184NW · Substantial damageNTSB ERA22LA268Accident · No injuriesClass 3 · LimitedFinal reportWingren Norman Escapade · Brasstown, NCThe failure of the engine gearbox drive flange, which resulted in a nose gear collapse during the subsequent precautionary landing in tall grass.May 9, 2022 · N86RD · Substantial damageNTSB ERA22LA237Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA42 · Lehighton, PAThe flight instructor’s inadequate supervision of the flight and his failure to secure the right engine following an unsuccessful engine restart attempt, which resulted in the airplane’s inability to maintain altitude and a subsequent off-airport landing.May 9, 2022 · N988JA · Substantial damageNTSB WPR22FA173Accident · 2 fatalClass 3 · FieldFinal reportBlue Side UP Comp AIR 8 SS52 · Grasmere, IDThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.May 8, 2022 · N801DT · Substantial damageNTSB CEN22LA195Accident · No injuriesClass 3 · LimitedFinal reportSwearingen SA226-T(B) · Denver, COThe captain’s failure to ensure that the parking brake was correctly released before takeoff, which resulted in seized brakes during landing and a subsequent loss of directional control and runway excursion.May 6, 2022 · N36LC · Substantial damageNTSB CEN22LA190Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421 · Houston, TXThe fixed-base operator’s incorrect fueling of the airplane, which resulted in a total loss of power in both engines.May 6, 2022 · XB-FQS · Substantial damageNTSB ERA22LA239Accident · No injuriesClass 3 · LimitedFinal reportThrush S2R · Hawkinsville, GAA failure of the electric main fuel pump due to the carbon brushes having completely worn away.May 5, 2022 · N6216M · Substantial damageNTSB ERA22LA222Accident · No injuriesClass 4 · LimitedFinal reportCharles R Kyle Zenith Stol CH 701 · Culpepper, VAThe pilot’s failure to maintain the proper glidepath, which resulted in a hard landing and landing gear collapse.May 5, 2022 · N701VX · Substantial damageNTSB CEN22LA191Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV6A · Mankato, MNThe pilot’s failure to maintain directional control while landing with a higher airspeed.May 4, 2022 · N5060 · Substantial damageNTSB ERA22LA219Accident · No injuriesClass 4 · LimitedFinal reportShort Bros SD3-60 · San Juan, PRThe flight crew’s failure to extend the landing gear before landing.May 3, 2022 · N744LG · Substantial damageNTSB ERA22FA218Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Altha, FLThe pilot’s failure to perform a preflight weight and balance calculation and his operation of the flight at an excessive takeoff weight, resulting in an exceedance of the airplane’s critical angle of attack after liftoff and an aerodynamic stall from which…May 3, 2022 · N6413B · DestroyedNTSB WPR22LA170Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22/135 · Mesa, AZThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.May 2, 2022 · N3390A · Substantial damageNTSB ERA22LA221Accident · No injuriesClass 4 · LimitedFinal reportKyle M Sward / Larry W Sward CH 750 Cruzer · Lexington, KYThe pilot's failure to maintain directional control during landing.May 2, 2022 · N750LK · Substantial damageNTSB ERA22LA216Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman AA1 · Seneca, SCA dislodged air filter element, which restricted airflow to the carburetor resulting in a loss of engine power.May 2, 2022 · N15LM · Substantial damageNTSB ERA22LA215Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 414 · Connellsville, PAThe pilot/mechanic’s failure to properly secure two airplane avionics units, which resulted in the trays supporting the units to sag downward and become lodged in the movement area of the elevator bellcrank during the accident takeoff.May 2, 2022 · N46TA · Substantial damageNTSB CEN22LA193Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6D · Huntington, INLoss of directional control during landing that resulted in an impact with terrain.May 2, 2022 · N515SA · Substantial damageNTSB ERA22LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Toms River, NJLoss of engine power due to the throttle linkage becoming disconnected in flight due to improper maintenance.May 1, 2022 · N737LY · Substantial damageNTSB ERA22LA214Accident · No injuriesClass 4 · LimitedFinal reportNorth American SNJ-6 · Greenwood, SCThe loss of directional control due to a fractured tailwheel steering linkage assembly.May 1, 2022 · N451WA · Substantial damageNTSB WPR22FA169Accident · 2 fatalClass 3 · FieldFinal reportBearhawk LSA · Kalispell, MTAn excessive pitch control input for undetermined reasons while the airplane was operating above maneuvering speed, which led to a structural failure of the right wing during cruise flight. Contributing to the accident was the poor construction quality of the…Apr 30, 2022 · N1908A · Substantial damageNTSB ERA22LA212Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Hampton, GAThe student pilot’s application of excessive left brake during the landing roll, resulting in a loss of directional control and a runway excursion. The flight instructor’s inadequate remedial action was a factor in the accident.Apr 30, 2022 · N5704R · Substantial damageNTSB CEN22LA189Accident · No injuriesClass 3 · LimitedFinal reportRaytheon A36 · Blanket, TXThe pilot’s failure to properly manage fuel while enroute, which resulted in a loss of engine power due to fuel starvation and a subsequent forced landing.Apr 30, 2022 · N47JB · Substantial damageNTSB CEN22LA188Accident · No injuriesClass 3 · LimitedFinal reportBeech B-99 · Milwaukee, WIA right main landing gear collapse due to fatigue failure of the landing gear drag leg support fitting.Apr 30, 2022 · N699CZ · Substantial damageNTSB CEN22LA187Accident · No injuriesClass 3 · LimitedFinal reportNorth American AT-6D · Fredericksburg, TXA total loss of engine power due to a failure of the No. 1 cylinder.Apr 30, 2022 · N29947 · Substantial damageNTSB CEN22LA186Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Loogootee, INThe inadequate maintenance and subsequent failure of an internal component in the fuel servo that prevented adequate fuel flow to the engine, which resulted in a partial loss of engine power.Apr 30, 2022 · N4303P · Substantial damageNTSB WPR22LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Portland, ORThe pilot’s failure to maintain directional control during landing on a wet surface with a tailwind, which resulted in a runway excursion.Apr 29, 2022 · N20640 · Substantial damage