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 ERA21LA099Accident · No injuriesClass 3 · LimitedFinal reportDiamond DA 40 · Portsmouth, NHThe instructor’s multiple applications of the airplane’s brakes during high-speed taxi over a short duration, which overheated and ignited the right main landing gear wheel brake assembly.Jan 3, 2021 · N489RS · Substantial damageNTSB WPR21LA078Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Moab, UTThe pilot’s improper application of full throttle during takeoff, which resulted in loss of engine power due to an excessive fuel flow and overly rich fuel mixture.Jan 2, 2021 · N833RT · Substantial damageNTSB CEN21LA104Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA-24-250 · New Hudson, MIThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of an instrument rating and the low visibility at the time…Jan 2, 2021 · N8347P · DestroyedNTSB WPR21LA079Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20-135 · Riverside, UTA failure of the throttle control during a landing roll, which resulted in a loss of control and collision with a fence.Jan 1, 2021 · N1571A · Substantial damageNTSB WPR21LA077Accident · Minor injuriesClass 4 · LimitedFinal reportBell 47D · Marana, AZThe pilot's failure to maintain helicopter control, which resulted in a hard landing.Jan 1, 2021 · N74823 · Substantial damageNTSB ENG21LA011Incident · No injuriesClass 3 · LimitedFinal reportCessna 501 · Opa Locka, FLAn uncontained left engine failure caused by a low cycle fatigue crack that originated from a manufacturing machining groove on the high pressure compressor impeller aft face. Contributing to the incident was service bulletin borescope inspection criteria…Dec 31, 2020 · N75TL · Minor damageNTSB ERA21LA238Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46R-350T · York, PAAn improper weld repair of the engine mount, which resulted in a fatigue failure of the mount and subsequent nose landing gear collapse. Contributing to the accident was maintenance personnel’s failure to accomplish the manufacturer’s service bulletin…Dec 30, 2020 · N463ST · Substantial damageNTSB ERA21LA097Accident · No injuriesClass 4 · LimitedFinal reportMooney International M20TN · Holly Ridge, NCThe pilot’s failure to perform a go-around during an unstable approach to land which resulted in a landing area overshoot and a subsequent runway excursion.Dec 30, 2020 · N728VM · Substantial damageNTSB ERA21LA096Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12 · Topping, VAThe pilot’s failure to maintain directional control during landing, with resulted in a ground loop and subsequent nose over.Dec 30, 2020 · N96540 · Substantial damageNTSB ERA21LA094Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Stowe, PAThe pilot's loss of directional control while landing in a gusty crosswind, which resulted in a runway excursion and subsequent impact with terrain.Dec 29, 2020 · N6327F · Substantial damageNTSB ERA21LA093Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Westfield, MAThe pilot’s failure to maintain control of the airplane during the landing and his failure to confirm that the landing gear was extended before landing.Dec 29, 2020 · N916MT · Substantial damageNTSB CEN21LA103Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · Cypress, TXA total loss of engine power due to fuel exhaustion.Dec 29, 2020 · N3702R · Substantial damageNTSB CEN21LA102Accident · 1 fatalClass 3 · LimitedFinal reportHughes 369D · Tuckers Crossing, MSThe pilot’s loss of helicopter control when the external saw contacted trees during an attempted emergency landing due to a main rotor transmission oil pressure warning. The reason that the pilot did not release the external saw from the helicopter during the…Dec 29, 2020 · N103SU · DestroyedNTSB CEN21LA101Accident · No injuriesClass 3 · LimitedFinal reportBeech 65-A80-8800 · Alexandria, MNThe pilot’s decision to attempt takeoff with frost covering the airplane and rotating below the published rotation speed, which led to exceedance of the airplane’s critical angle of attack and an aerodynamic stall.Dec 29, 2020 · N134BA · Substantial damageNTSB WPR21LA075Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35 · Santa Ynez, CAThe pilot’s mismanagement of fuel, which resulted in fuel starvation and a total loss of engine power.Dec 28, 2020 · N5474D · Substantial damageNTSB CEN21LA105Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Navasota, TXThe pilot’s failure to extend the landing gear before landing.Dec 28, 2020 · N1236 · Substantial damageNTSB ERA21LA091Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Pleasant Valley, NYA total loss of engine power due to failure of the magnetos, which were not overhauled in accordance with the manufacturer’s time specifications.Dec 27, 2020 · N8311X · Substantial damageNTSB ERA21LA089Accident · Serious injuriesClass 4 · LimitedFinal reportGlasflugel Club Libelle 205 · Bunn, NCThe pilot's failure to maintain adequate clearance from trees during an off-airport landing.Dec 27, 2020 · N205HL · Substantial damageNTSB ERA21LA090Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Locust Grove, GAThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control and subsequent runway excursion.Dec 26, 2020 · N75825 · Substantial damageNTSB CEN21LA098Accident · Serious injuriesClass 4 · LimitedFinal reportQuad City Challenger II · Waldron, MOThe pilot’s improper landing flare during the rejected takeoff that resulted in a hard landing and nose landing gear collapse.Dec 26, 2020 · N895BT · Substantial damageNTSB CEN21LA100Accident · Serious injuriesClass 3 · LimitedFinal reportWalton Daniel J Sonex · Pecatonica, ILA total loss of engine power for reasons that could not be determined based on the available information, and the pilot’s exceedance of the airplane’s critical angle of attack following the loss of engine power, which resulted in an aerodynamic stall/spin and…Dec 24, 2020 · N610DJ · Substantial damageNTSB ERA21LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Madisonville, TNThe pilot's failure to maintain directional control during the landing rollout, which resulted in a ground loop.Dec 22, 2020 · N4580C · Substantial damageNTSB ERA21LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Culpeper, VAThe pilot’s decision to land the airplane in crosswind conditions that exceeded the airplane’s maximum demonstrated crosswind velocity.Dec 22, 2020 · N505LP · Substantial damageNTSB WPR21LA072Accident · No injuriesClass 3 · LimitedFinal reportNavion Navion A · Livermore, CAThe improper installation of the gascolator fuel inlet line and hose clamp connection, which resulted in the total loss of engine power.Dec 21, 2020 · N4106K · Substantial damageNTSB CEN21LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 150K · Peyton, COThe student pilot did not maintain directional control of the airplane while landing. Contributing to the accident was the pilot’s diverted attention to the incorrect flap setting.Dec 21, 2020 · N5937G · Substantial damageNTSB CEN21LA096Accident · 2 fatalClass 3 · LimitedFinal reportExpress CT · Grand Prairie, TXThe pilot’s loss of airplane control during the departure turn, which resulted in an aerodynamic stall and impact with terrain.Dec 21, 2020 · N772BM · DestroyedNTSB CEN21LA095Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Morris, ILThe pilot's inadequate pedal application during liftoff with a tailwind, which resulted in a loss of yaw control and a subsequent impact with terrain.Dec 20, 2020 · N3264U · Substantial damageNTSB ERA21LA087Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA46 · Naples, FLThe inadvertent activation of the unguarded ferry tank fuel selector valve, which resulted in fuel starvation and a total loss of engine power.Dec 19, 2020 · N662TC · Substantial damageNTSB CEN21LA092Accident · 1 fatalClass 3 · LimitedFinal reportSonex Tailwheel · Burleson, TXA total loss of engine power due to engine seizure. Contributing to the accident was the pilot decision not to orbit the airport, as originally planned.Dec 19, 2020 · N935EK · Substantial damageNTSB ERA21LA081Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Tampa, FLA total loss of engine power due to the student pilot inadvertently moving the fuel selector to the OFF position.Dec 18, 2020 · N6978W · DestroyedNTSB CEN21LA097Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Albion, NEThe pilot’s failure to maintain directional control during the landing with a tailwind.Dec 18, 2020 · N9590A · Substantial damageNTSB ERA21LA080Accident · 1 fatalClass 3 · LimitedFinal reportSocata TB10 · Pembroke Pines, FLThe pilot’s failure to use carburetor heat in environmental conditions favorable for serious carburetor ice during a prolonged wait with the engine at a low power setting before takeoff, which resulted in a partial loss of engine power due to carburetor ice.…Dec 17, 2020 · N5547Y · DestroyedNTSB CEN21LA091Accident · 1 fatalClass 3 · LimitedFinal reportExtra Flugzeugproduktions-Und EA 300/L · Aledo, TXThe pilot’s loss of control during an intentional aerobatic maneuver, which resulted in an upright spin into terrain.Dec 17, 2020 · N102JK · Substantial damageNTSB WPR21LA070Accident · 1 fatalClass 3 · LimitedFinal reportSilverLight AR-1 · Heber City, UTThe pilot’s failure to follow the procedures for takeoff in the Pilot Operating Handbook, which resulted in a loss of control and collision with the terrain. Contributing to the accident was the pilot’s failure to receive additional training in the gyroplane.Dec 16, 2020 · N261MD · Substantial damageNTSB ERA21LA077Accident · No injuriesClass 3 · LimitedFinal reportEmbraer EMB-500 · Jacksonville, FLThe flight crew’s failure to apply maximum braking immediately upon touchdown, which resulted in a runway excursion. Contributing to the accident were 1) the slightly excessive approach airspeed and 2) the flight crew’s decision to land on a wet runway during…Dec 16, 2020 · N661EP · Substantial damageNTSB CEN21LA089Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA28 · Bossier City, LAThe student pilot’s decision to conduct a flight during night instrument meteorological conditions and his loss of airplane control due to spatial disorientation. Contributing to the accident was the student pilot’s use of an amphetamine and his attention…Dec 16, 2020 · N55168 · DestroyedNTSB CEN21LA088Accident · 2 fatalClass 3 · LimitedFinal reportRans S12XL · Port Isabel, TXAn exceedance of the airplane’s critical angle of attack and aerodynamic stall following a loss of engine power during an unknown phase of flight, which resulted in an impact with terrain.Dec 16, 2020 · N449JP · Substantial damageNTSB ERA21LA078Accident · Minor injuriesClass 4 · LimitedFinal reportLake LA-4-200 · Orlando, FLThe pilot’s improper recovery from a bounced landing.Dec 15, 2020 · N5023L · Substantial damageNTSB CEN21LA086Accident · No injuriesClass 4 · LimitedFinal reportEclipse EA 500 · Leadville, COThe pilot’s failure to maintain proper control of the airplane, which led to an unstabilized approach and a long landing on a runway contaminated with ice and patchy packed snow resulting in a runway excursion.Dec 14, 2020 · N686TM · Substantial damageNTSB WPR21LA069Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · San Diego, CAA partial loss of engine power due to the fatigue fracture of the No. 3 exhaust valve rocker arm stud.Dec 13, 2020 · N5098E · Substantial damageNTSB ERA21LA073Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctsw · Marion, NCThe pilot’s failure to maintain airplane control during takeoff, resulting in a rejected takeoff and runway excursion.Dec 13, 2020 · N138CT · Substantial damageNTSB ERA21LA071Accident · 1 fatalClass 3 · LimitedFinal reportAnthony Mattioli AR-1 · San Mateo, FLA loss of engine power due to fuel contamination.Dec 12, 2020 · N11TG · Substantial damageNTSB ERA21LA068Accident · 1 fatalClass 3 · LimitedFinal reportBeech V35A · Attalla, ALA loss of control inflight and the failure of a component of the up elevator flight control system due to fatigue, which rendered recovery from a right descending turn improbable.Dec 12, 2020 · N5470U · DestroyedNTSB ERA21LA079Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Nantucket, MAThe pilot's failure to maintain adequate clearance from obstacles during the attempted go around following an approach to landing in sun glare.Dec 11, 2020 · N8436T · Substantial damageNTSB ERA21LA075Accident · No injuriesClass 3 · LimitedFinal reportKolb Firestar · Durham, NCA total loss of engine power due to fuel starvation as the result of a degraded fuel primer check valve.Dec 11, 2020 · N7094T · Substantial damageNTSB ERA21LA074Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Dexter, METhe pilot’s loss of directional control while landing, which resulted in an encounter with snow and subsequent nose over.Dec 11, 2020 · N19801 · Substantial damageNTSB WPR21LA068Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Ogden, UTThe partial loss of engine power for reasons that cannot be determined due to lack of available evidence.Dec 10, 2020 · N577CP · Substantial damageNTSB CEN21LA084Accident · 2 fatalClass 3 · LimitedFinal reportRobinson R44 · Colorado City, TXThe pilot’s loss of control and exceedance of performance and/or structural limitations during low-altitude operations, which resulted in an inflight breakup.. Contributing to the accident was the pilot’s impairment from the effects of tetrahydrocannabinol.Dec 10, 2020 · N7085Z · DestroyedNTSB ERA21LA084Accident · No injuriesClass 4 · LimitedFinal reportFord Stephen L Super Chief · Blountstown, FLThe pilot's failure to maintain directional control of the airplane during the landing.Dec 9, 2020 · N706SF · Substantial damageNTSB WPR21LA067Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Dillon, MTThe student pilot’s exceedance of the airplane’s critical angle attack during an attempted go-around, which resulted in an aerodynamic stall.Dec 8, 2020 · N46017 · Substantial damage