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 WPR18LA037Accident · No injuriesClass 3 · LimitedFinal reportColumbia Aircraft Mfg LC41 550FG · Oro Valley, AZThe inadequate cooling time between repeated heavy braking applications, which resulted in the brakes overheating and a subsequent brake fire during the aborted takeoff sequence.Nov 27, 2017 · N2526C · Substantial damageNTSB GAA18CA058Accident · No injuriesData collectionFinal reportCessna 182 · Black River Falls, WIThe student pilot’s failure to maintain lateral control of the high-performance airplane during the go-around in crosswind conditions.Nov 27, 2017 · N8128M · Substantial damageNTSB CEN18LA042Accident · No injuriesLimited investigationFinal reportMotley Gary W Zenith CH750 Cruzer · Louviers, COThe engine’s excessive cylinder head temperatures and the subsequent seizing of the engine, which resulted from an engine control unit that caused the engine’s fuel-air mixture to be too lean.Nov 27, 2017 · N956GM · Substantial damageNTSB GAA18CA080Accident · No injuriesData collectionFinal reportCessna 172 · Daytona Beach, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing.Nov 26, 2017 · N452ER · Substantial damageNTSB GAA18CA059Accident · No injuriesData collectionFinal reportMooney M20 · Tucson, AZThe pilot’s inadequate preflight and in-flight fuel management, which resulted in an intermittent loss of engine power due to fuel starvation.Nov 26, 2017 · N6002Q · Substantial damageNTSB CEN18LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Midland, TXThe improper installation of the generator by unknown personnel, which resulted in a loss of oil and subsequent engine failure.Nov 26, 2017 · N8637S · Substantial damageNTSB CEN18LA038Accident · Serious injuriesLimited investigationFinal reportPiper / Laudeman J3C 65 · Palmyra, WIThe pilot’s inadvertent pulling of the fuel shutoff valve, which resulted in a total loss of engine power and a subsequent forced landing into trees. Contributing to the pilot’s inadvertent pulling of the fuel shutoff valve were habit patterns he had…Nov 26, 2017 · N11188 · Substantial damageNTSB WPR18LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Odessa, FLA loss of engine power due to fuel starvation as a result of the pilot's inadequate planning and in-flight fuel management. Contributing to the accident was the pilot’s failure to follow proper procedures after the loss of engine power.Nov 25, 2017 · N57351 · Substantial damageNTSB WPR18LA036Accident · Minor injuriesClass 3 · LimitedFinal reportDoshier Wilbert A GT-500 · Willows, CAA loss of engine power during takeoff due a coolant leak and the subsequent overheating of the engine, and the student pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall…Nov 25, 2017 · N599RA · Substantial damageNTSB ERA18LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-220T · Ebensburg, PAThe pilot's improper decision to fly an airplane with a known oil leak, which led to a total loss of engine power due to oil starvation. Contributing to the accident was the pilot's decision to land with a tailwind, which led to his attempted go-around and…Nov 25, 2017 · N263DM · Substantial damageNTSB ANC18LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Oloh, MSA partial loss of engine power due to the failure of the No. 3 valve key (exhaust).Nov 25, 2017 · N739KW · Substantial damageNTSB GAA18CA065Accident · No injuriesData collectionFinal reportAveko Sro VL-3C-1 · Northampton, MAThe pilot’s improper landing flare, which resulted in a loss of directional control and subsequent impact with approach lighting.Nov 24, 2017 · N876MB · Substantial damageNTSB GAA18CA061Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Caldwell, TXThe pilot’s failure to maintain yaw control and the exceedance of the airplane’s critical angle of attack in the traffic pattern, which resulted in an aerodynamic stall/spin.Nov 23, 2017 · N1780K · Substantial damageNTSB GAA18CA056Accident · No injuriesData collectionFinal reportBuehlmann Peter Kitfox Model 4 1200 · Overgaard, AZThe pilot’s failure to maintain directional control during the landing roll.Nov 23, 2017 · N234PB · Substantial damageNTSB ERA18FA030Accident · 1 fatalField investigationFinal reportMooney M20C · Starke, FLThe pilot's loss of control due to spatial disorientation while maneuvering in instrument meteorological conditions. Contributing was the pilot's lack of instrument currency and his self-induced pressure to complete the flight.Nov 23, 2017 · N6894N · DestroyedNTSB GAA18CA060Accident · No injuriesData collectionFinal reportHughes 300 · Woodlawn, VAThe pilot’s inappropriate descent profile during landing with a quartering gusting tailwind, which resulted in a loss of main rotor rpm.Nov 22, 2017 · N9685F · Substantial damageNTSB ERA18LA033Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Presque Isle, METhe in-flight leakage of fuel from the fuel injection system's mixture shaft onto the hot turbocharger, which resulted in an in-flight fire, and the pilot's inability to see the runway due to reduced visibility conditions and conduct a successful landing.Nov 22, 2017 · N421RX · Substantial damageNTSB CEN18LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Maple Lake, MNThe pilot’s failure to maintain directional control while landing, which resulted in a runway excursion.Nov 22, 2017 · N734VH · Substantial damageNTSB CEN18LA043Accident · No injuriesLimited investigationFinal reportRutten Phil J Pietenpol · De Kalb, ILThe pilot’s excessive rudder and brake applications during landing, which caused the airplane to nose over.Nov 22, 2017 · N502R · Substantial damageNTSB CEN18LA041Accident · No injuriesLimited investigationFinal reportCessna 182S · Bolingbrook, ILThe pilot’s failure to maintain directional control during takeoff.Nov 22, 2017 · N7111W · Substantial damageNTSB CEN18LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA 12 · Dickinson, NDThe pilot’s failure to attain adequate airspeed during the short field takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.Nov 22, 2017 · N4040M · Substantial damageNTSB CEN18FA037Accident · 1 fatalField investigationFinal reportCessna 172G · Pittsford, VTThe pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.Nov 22, 2017 · N4676L · DestroyedNTSB GAA18CA055Accident · No injuriesData collectionFinal reportBellanca 8KCAB · El Dorado, MOThe pilot’s failure to maintain directional control during the landing roll.Nov 21, 2017 · N62979 · Substantial damageNTSB CEN18LA034Accident · No injuriesLimited investigationFinal reportErcoupe 415 CD · Aurora, COThe failure of the engine-driven fuel pump and the pilot's failure to identify the pump's failure, which resulted in a loss of engine power due to fuel starvation and a forced landing on a road, during which the airplane hit obstacles.Nov 20, 2017 · N3067H · Substantial damageNTSB CEN18FA035Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Electra, TXThe pilot's failure to maintain clearance from powerlines while maneuvering at low altitude.Nov 20, 2017 · N4179M · Substantial damageNTSB WPR18LA034Accident · Serious injuriesClass 2 · LimitedFinal reportCessna 172P · San Jose, CAThe pilot's delayed decision to execute an emergency landing and his attempt to return to the airport following a partial loss of power due to wear on internal engine components, which prevented the engine from developing full-rated power during the…Nov 19, 2017 · N52492 · Substantial damageNTSB GAA18CA050Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Rosamond, CAThe pilot’s failure to maintain directional control during the landing roll.Nov 19, 2017 · N69656 · Substantial damageNTSB GAA18CA049Accident · Minor injuriesData collectionFinal reportJohn Roscoe Autogyro Cavalon · Casa Grande, AZThe pilot’s improper landing flare, which resulted in loss of directional control and a subsequent runway excursion.Nov 19, 2017 · N953LS · DestroyedNTSB ERA18LA026Accident · No injuriesLimited investigationFinal reportPiper PA28 · Bladenboro, NCA loss of engine power due to carburetor icing and the presence of an insect nest in the carburetor heat control box that prevented the pilot’s application of carburetor heat from restoring engine power.Nov 18, 2017 · N8758N · Substantial damageNTSB WPR18LA033Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28R-201T · Nipton, CAA loss of engine power due to the detonation of the No. 5 cylinder due to excessive leaning at high power settings, which resulted in a forced landing and the subsequent hard touchdown.Nov 17, 2017 · N5966V · Substantial damageNTSB ERA18LA038Accident · No injuriesClass 3 · LimitedFinal reportBeech B 55 · Statesville, NCA total loss of left engine power during initial climb. Contributing to the accident was the pilot's failure to maintain control of the airplane following the loss of engine power.Nov 17, 2017 · N592SS · Substantial damageNTSB GAA18CA064Accident · No injuriesData collectionFinal reportCessna 172 · Pompano, FLThe pilot’s improper landing flare, which resulted in a porpoise.Nov 16, 2017 · N75919 · Substantial damageNTSB GAA18CA053Accident · No injuriesData collectionFinal reportPiper PA 28R · Melborne, FLThe pilot’s loss of directional control during the landing roll on the wet runway.Nov 16, 2017 · N5381F · Substantial damageNTSB ANC18LA009Accident · No injuriesLimited investigationFinal reportCessna 172RG · Opa Locka, FLA failure of the airplane 's electrical system, which led to the failure of the landing gear system, for reasons that could not be determined because postaccident examination and testing revealed no mechanical anomalies that would have precluded normal…Nov 16, 2017 · N6102R · Substantial damageNTSB CEN18LA032Accident · Serious injuriesLimited investigationFinal reportCessna T207A · Rock Springs, WYThe pilot's improper in-flight fuel management and reliance on a faulty fuel gauge, which resulted in fuel starvation during approach for landing, and his failure to follow the emergency checklist after losing engine power.Nov 15, 2017 · N9825M · Substantial damageNTSB GAA18CA046Accident · No injuriesData collectionFinal reportTextron 172 · Columbus, OHThe student pilot’s improper landing flare, which resulted in a porpoise.Nov 14, 2017 · N30SU · Substantial damageNTSB WPR18LA030Accident · No injuriesLimited investigationFinal reportVanderark RV-10 · Sun Lakes, AZThe fatigue fractures of the upper and lower alternator attachment bolts, which decreased the common drive belt tension and resulted in the subsequent in-flight separation of an alternator drive belt, the overheating of the engine, and the subsequent total…Nov 12, 2017 · N917VA · Substantial damageNTSB ERA18FA022Accident · 4 fatalField investigationFinal reportPiper PA32 · Fountain Run, KYThe noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to complete…Nov 12, 2017 · N3371W · DestroyedNTSB CEN18LA031Accident · No injuriesLimited investigationFinal reportCessna T210N · Grayslake, ILThe failure of the No. 4 connecting rod due to inadequate oil lubrication for reasons that could not be determined because the postaccident engine examination did not reveal any anomalies that would have caused a lack of lubrication.Nov 12, 2017 · N5300A · Substantial damageNTSB WPR18LA031Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 · Page, AZThe pilot's failure to maintain pitch control of the helicopter while transitioning from a hover to forward flight.Nov 11, 2017 · N744BS · Substantial damageNTSB GAA18CA042Accident · No injuriesData collectionFinal reportStinson SR 5E · Burlington, WAThe pilot’s unstabilized approach, which resulted in a hard, bounced landing and nose-over. Also causal to the accident was the pilot’s improper decision to land on a closed alternate grass landing area.Nov 11, 2017 · N141WC · Substantial damageNTSB ANC18LA008Accident · No injuriesLimited investigationFinal reportCloud Jeffrey Ferrell Long EZ · Eufaula, ALThe in-flight separation of a portion of the propeller, which subsequently penetrated the right rudder, as a result of the failure of the bond line between two of the propeller’s wood layers. Contributing to the failure of the propeller was the manufacturer’s…Nov 11, 2017 · N754T · Substantial damageNTSB GAA18CA039Accident · No injuriesData collectionFinal reportCessna 180 · Panama City, FLThe pilot's failure to maintain lateral/bank control during landing in gusting crosswind conditions.Nov 10, 2017 · N6547A · Substantial damageNTSB ERA18LA021Accident · No injuriesClass 2 · LimitedFinal reportSocata TB200 · Annapolis, MDA loss of engine power for undetermined reasons after the disconnection of the propeller governor control due to inadequate securenment during maintenance.Nov 10, 2017 · N207GT · Substantial damageNTSB CEN18FA030Accident · 1 fatalField investigationFinal reportTemco GC 1B · Pineville, LAThe loss of engine power due to fuel starvation, which resulted from the unporting of the fuel during a right turn due to the auxiliary fuel tanks' improper configuration.Nov 10, 2017 · N2363B · Substantial damageNTSB GAA18CA045Accident · No injuriesData collectionFinal reportCessna 172 · Trenton, NJThe pilot’s improper landing flare, which resulted in a bounced landing.Nov 9, 2017 · N2138W · Substantial damageNTSB GAA18CA047Accident · No injuriesData collectionFinal reportCessna 140 · Macon, GAThe pilot's incorrect pitch control during takeoff, which resulted in a nose-over.Nov 8, 2017 · N76238 · Substantial damageNTSB ERA18FA016Accident · 2 fatalField investigationFinal reportPiper PA 32 · Morrison, TNThe pilots' loss of control during a missed approach in night instrument meteorological conditions as a result of spatial disorientation.Nov 8, 2017 · N47831 · DestroyedNTSB CEN18LA044Accident · No injuriesLimited investigationFinal reportCessna 170B · Harvard, ILThe failure of the universal joint in the pilot-side flight control yoke due to the fatigue fracture of a rivet within the universal joint. Contributing to the universal joint failure was the universal joint design, which was prone to galling wear and seizure.Nov 8, 2017 · N2766D · Substantial damageNTSB WPR18LA029Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Rolling Fork, MSAn uncommanded yaw and subsequent loss of main rotor rpm for reasons that could not be determined.Nov 7, 2017 · N93PH · Substantial damage