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 CEN21LA260Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Denton, TXThe flight instructor and student pilot’s failure to properly manage the airplane’s available fuel resulting in fuel starvation.Jun 10, 2021 · N4147J · Substantial damageNTSB ERA21LA247Accident · Minor injuriesClass 3 · LimitedFinal reportGarrison Ronald L Zodiac 601 XL · Cumberland, MDAn inadvertent release of the canopy, which allowing the canopy to open during flight and led to an inflight loss of airplane control. Contributing to the accident was the lack of any safeguard to prevent the inadvertent opening of the canopy.Jun 8, 2021 · N315SV · Substantial damageNTSB WPR21FA223Accident · 1 fatalClass 3 · FieldFinal reportVans RV6 · Porterville, CAA loss of engine power for reasons that could not be determined based on available information.Jun 7, 2021 · N94PJ · DestroyedNTSB ERA21LA241Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-24-260 · Robbinsville, NJThe pilot’s mismanagement of fuel, which resulted in a total loss of engine power.Jun 6, 2021 · N79RG · Substantial damageNTSB ERA21FA239Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS 1-35 · Wurtsboro, NYThe pilot’s low-altitude release from tow for reasons that could not be determined, and his subsequent exceedance of the glider’s critical angle of attack while returning to the runway, which resulted in an aerodynamic stall and impact with terrain.Jun 6, 2021 · N2878H · Substantial damageNTSB ANC21LA045Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Chandalar Lake, AKThe pilot’s over application of the brakes, which resulted in a nose over.Jun 6, 2021 · N85DT · Substantial damageNTSB WPR21LA282Accident · No injuriesClass 4 · LimitedFinal reportJabiru USA Sport J230-SP · Oceano, CAThe pilot’s failure to maintain directional control after landing fast and hard which damaged the right main landing gear wheel pant which lodged under the wheel.Jun 5, 2021 · N733J · Substantial damageNTSB ERA21LA251Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24 · Monticello, NYThe pilot’s inadequate preflight inspection which resulted in a failure of the right main landing gear tire on landing rollout, a subsequent loss of directional control, and landing gear collapse.Jun 5, 2021 · N5779P · Substantial damageNTSB ERA21LA244Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Sanford, METhe pilot’s failure to maintain directional control while landing in gusting wind conditions.Jun 5, 2021 · N7776S · Substantial damageNTSB ERA21LA243Accident · No injuriesClass 4 · LimitedFinal reportJabiru USA Sport J250-SP · Marietta, PAThe pilot’s failure to maintain directional control during the landing roll.Jun 5, 2021 · N214RM · Substantial damageNTSB ERA21LA240Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Warwick, NYThe pilot’s failure to attain a proper touchdown point, which resulted in the airplane contacting the ground short of the runway.Jun 5, 2021 · N1899N · Substantial damageNTSB CEN21LA255Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Alexandria, MNThe pilot did not maintain aircraft and directional control during the landing in variable wind conditions resulting in abnormal contact with the terrain.Jun 5, 2021 · N3697V · Substantial damageNTSB CEN21LA251Accident · Minor injuriesClass 4 · LimitedFinal reportKevin Lippert Zenith CH 750 · Montrose, COThe loss of engine power due to fuel vapor lock.Jun 5, 2021 · N902KL · Substantial damageNTSB ERA21LA246Accident · No injuriesClass 3 · LimitedFinal reportHonda HA-420 · Kennesaw, GAThe mechanic’s improper installation of the left main wheel assembly.Jun 4, 2021 · N10XN · Substantial damageNTSB CEN21LA259Accident · No injuriesClass 3 · LimitedFinal reportCessna 560XL · Aspen, COThe malfunction of the landing gear handle for reasons that could not be determined, which caused the right main landing gear to collapse during the landing roll.Jun 4, 2021 · N615RG · Substantial damageNTSB CEN21LA250Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV9 · West Portsmouth, OHThe pilot’s improper use of the airplane’s fuel system, which resulted in a total loss of engine power due to fuel starvation.Jun 4, 2021 · N20YY · Substantial damageNTSB CEN21LA256Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · San Angelo, TXInadequate maintenance of the left main landing gear strut, which resulted in a landing gear collapse.Jun 3, 2021 · N2120J · Substantial damageNTSB CEN21LA253Accident · No injuriesClass 4 · LimitedFinal reportSchweizer TH55A/269A · Monroe, LAThe pilot’s failure to maintain yaw control during landing which resulted in a loss of tail rotor effectiveness.Jun 3, 2021 · N41G · Substantial damageNTSB CEN21LA248Accident · No injuriesClass 3 · LimitedFinal reportBeech 1900 · Denver, COThe pilot’s failure to properly configure the airplane for landing, which resulted in a gear-up landing.Jun 3, 2021 · N219VP · Substantial damageNTSB WPR21LA224Accident · No injuriesClass 3 · LimitedFinal reportCessna 172G · Washington, CAA total loss of engine power during an enroute climb due to a stuck exhaust valve and multiple failed piston compression rings.Jun 2, 2021 · N3871L · Substantial damageNTSB CEN21LA257Accident · No injuriesClass 3 · LimitedFinal reportQuad City Challenger · Wallingford, IAImpact with trees and terrain during takeoff for reasons that could not be determined based on the available information.Jun 2, 2021 · N3281P · Substantial damageNTSB ERA21FA237Accident · 1 fatalClass 3 · FieldFinal reportBeech A23 · Pinnacle, NCThe flight instructor’s mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.Jun 1, 2021 · N8780M · Substantial damageNTSB WPR21LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Carlsbad, CAThe student pilot’s improper landing flare, which resulted in a bounced landing and subsequent loss of directional control.May 31, 2021 · N47UP · Substantial damageNTSB WPR21LA213Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Cashmere, WAA total loss of engine power shortly after takeoff for reasons that could not be determined based on the available information.May 31, 2021 · N7159B · Substantial damageNTSB ERA21LA242Accident · No injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Pittsfield, PAThe student pilot’s improper landing flare, which resulted in a hard landing and loss of directional control.May 31, 2021 · N912B · Substantial damageNTSB WPR21LA215Accident · Minor injuriesClass 4 · LimitedFinal reportCessna R182 · Minden, NVThe pilot receiving instruction’s failure to maintain directional control during the landing roll, and the flight instructor’s delayed remedial action.May 30, 2021 · N757ZZ · Substantial damageNTSB CEN21LA242Accident · Minor injuriesClass 3 · LimitedFinal reportPiper J4A · Omaha, NEA total loss of engine power due to a blocked fuel tank cap vent hole, which resulted in fuel starvation. Contributing to the accident was the mechanic’s and the pilot’s inadequate inspections of the fuel tank cap.May 30, 2021 · N8501Z · Substantial damageNTSB WPR21LA219Accident · Serious injuriesClass 3 · LimitedFinal reportStoddard Hamilton Glasair II · Darby, MTThe pilot’s impact with terrain during a go-around following an attempted precautionary landing due to a low oil pressure indication. The reason for the low oil pressure indication could not be determined based on the available information.May 29, 2021 · N8176J · Substantial damageNTSB WPR21LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Fields, ORThe pilot’s failure to maintain directional control during landingMay 29, 2021 · N89257 · Substantial damageNTSB WPR21LA212Accident · No injuriesClass 3 · LimitedFinal reportMaule M-5-235C · Stanley, IDThe pilot’s failure to use carburetor heat in weather conditions conducive to carburetor icing, resulting in a partial loss of engine power and a forced landing during which the airplane struck an object and nosed over.May 29, 2021 · N9254E · Substantial damageNTSB ERA21LA236Accident · Minor injuriesClass 4 · LimitedFinal reportMaxson Phil Zodiac CH601XL · Winder, GAPilot’s inadequate supervision of the pilot rated passenger’s actions, which led to a high descent rate and collision with obstacles.May 29, 2021 · N601MX · Substantial damageNTSB CEN21LA247Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Flint, MIThe pilot’s failure to adequately monitor his fuel quantity during flight which resulted in a partial loss of engine power due to fuel starvation.May 29, 2021 · N3992W · Substantial damageNTSB CEN21FA239Accident · 1 fatalClass 3 · FieldFinal reportPZL Warszawa-Okecie PZL-104 · Pearland, TXThe pilot’s loss of directional control during landing. Contributing to the severity of the accident was the presence of a drainage ditch between the runway and taxiway.May 29, 2021 · N124MS · Substantial damageNTSB WPR21LA225Accident · Serious injuriesClass 4 · LimitedFinal reportLindstrand Balloons 90A · Dayton, NVThe pilot’s failure to maintain control of the balloon due to an unexpected high surface wind and downdraft, which resulted in a hard landing.May 28, 2021 · N1535G · No damageNTSB CEN21LA241Accident · Serious injuriesClass 3 · LimitedFinal reportPipistrel Alpha Trainer · Fort Collins, COA partial loss of engine power due to the failure of the throttle control cable, which resulted in the loss of control of the dual carburetor system. The cable failure was a result of improper soldering at the throttle cable input terminal on the splitter…May 28, 2021 · N119JP · Substantial damageNTSB CEN21FA238Accident · 2 fatalClass 3 · FieldFinal reportLancair Evolution · McDermott, OHThe pilot’s failure to recognize and avoid airframe icing conditions, which resulted in a loss of airplane performance and a subsequent loss of control and in-flight break-up.May 28, 2021 · N515DL · DestroyedNTSB WPR21LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna TR182 · Prescott, AZThe pilot’s delayed deployment of the landing gear, which resulted in the collapse of the main landing gear.May 27, 2021 · N155CT · Substantial damageNTSB WPR21FA210Accident · 1 fatalClass 3 · FieldFinal reportMark Coby Early Bird Jenny · Stoneville, NCThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall and a loss of control.May 27, 2021 · N831HC · DestroyedNTSB CEN21LA243Accident · Serious injuriesClass 3 · LimitedFinal reportPhillips Ralph W Vans RV8 · San Angelo, TXThe loss of engine power due to fuel starvation. Contributing to the accident was the installation of a reduced flow fitting in the fuel line to the carburetor by maintenance personnel.May 27, 2021 · N274CV · Substantial damageNTSB ANC21LA042Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Birchwood, AKThe pilot's use of excessive braking during the landing roll, which resulted in a nose-over.May 27, 2021 · N659HC · Substantial damageNTSB WPR21LA208Accident · Minor injuriesClass 3 · LimitedFinal reportBoeing A75N1(PT17) · Hollister, CAThe improper installation of a relief valve spring that was shorter than the standard spring length, which slowed the response of the propeller governor to change the pitch of the blades during climbout, resulting in a partial loss of power.May 26, 2021 · N75016 · Substantial damageNTSB ERA21LA235Accident · No injuriesClass 4 · LimitedFinal reportMeyers Industries 200A · Marathon, FLThe failure of the right main landing gear to fully extend during landing as a result of the underinflated right main landing gear oleo strut.May 26, 2021 · N489C · Substantial damageNTSB ERA21FA233Accident · 4 fatalClass 3 · FieldFinal reportBhi H60 Helicopters UH-60A · Leesburg, FLThe failure of the water tank snorkel support structure, which allowed the snorkel to contact the main rotor blades. Contributing to the accident was insufficient Federal Aviation Administration oversight of the supplemental type certificate process for the…May 25, 2021 · N9FH · DestroyedNTSB ERA21FA232Accident · 1 fatalClass 3 · FieldFinal reportGulfstream American AA-5A · Crossville, TNA partial loss of engine power due to carburetor icing, which resulted in a descent and impact with terrain. Contributing to the accident was the pilot’s failure to apply carburetor heat following the initial loss of engine power.May 25, 2021 · N26889 · DestroyedNTSB CEN21LA246Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Indianapolis, INThe pilot’s improper landing flare, which resulted in a hard, bounced landing.May 25, 2021 · N162TW · Substantial damageNTSB WPR21FA203Accident · 1 fatalClass 3 · FieldFinal reportDassault Mirage F-1 · Las Vegas, NVThe pilot’s exceedance of the airplane’s critical angle of attack on approach and failure to fly a traffic pattern track consistent with a no-flap configuration. Contributing to the accident was the failure of the airplane’s flaps to extend while in the…May 24, 2021 · N567EM · DestroyedNTSB ERA21LA231Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8A · Skaneateles, NYThe pilot’s failure to maintain directional control during the takeoff roll which resulted in a runway excursion and nose-over event.May 24, 2021 · N1331K · Substantial damageNTSB ERA21FA229Accident · 1 fatalClass 3 · FieldFinal reportMunson Roger J RV-8 · Van Cleve, KYA loss of engine power due to loss of engine oil pressure.May 24, 2021 · N284RM · DestroyedNTSB CEN21LA236Accident · No injuriesClass 4 · LimitedFinal reportBerry TX-11C · Longmont, COThe pilot’s loss of directional control when his foot became stuck on a protruding bolt in the airplane’s floorboard.May 24, 2021 · N752T · Substantial damageNTSB WPR21LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Mesquite, NVThe pilot’s failure to maintain airplane control during the landing roll, which resulted in a nosed over.May 23, 2021 · N9557A · Substantial damage