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 GAA18CA012Accident · No injuriesData collectionFinal reportEurocopter Deutschland MBB BK 117 · Canton, ILThe flight instructor's incorrect cyclic control during a hover, which resulted in a hard landing.Oct 13, 2017 · N140SF · Substantial damageNTSB CEN18FA011Accident · 2 fatalField investigationFinal reportCessna 172M · Ramsey, MNThe pilot's decision to fly along the river at a low altitude contrary to applicable regulations and safety of flight considerations which resulted in the impact with the power lines. Contributing to the accident was the pilot's inability to see the and avoid…Oct 13, 2017 · N7CF · DestroyedNTSB GAA18CA011Accident · No injuriesData collectionFinal reportDehavilland DHC 1 · Cedartown, GAThe pilot’s failure to maintain directional control during the landing roll.Oct 12, 2017 · N323WG · Substantial damageNTSB CEN18LA013Accident · No injuriesLimited investigationFinal reportRussell E Oberg Murphy Rebel · Fort Collins, COA total loss of engine power due to carburetor ice accumulation. Contributing to the accident was the pilot’s failure to apply carburetor heat.Oct 12, 2017 · N734R · Substantial damageNTSB GAA18CA010Accident · No injuriesData collectionFinal reportAir Tractor AT 402B · Brawley, CAThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Oct 11, 2017 · N80060 · Substantial damageNTSB ANC18LA002Accident · No injuriesLimited investigationFinal reportFleetwood Jack Team Airbike · Ocean Springs, MSAn intermittent failure of the power take-off cylinder ignition coil, which resulted in a partial loss of engine power.Oct 11, 2017 · N7566D · Substantial damageNTSB WPR18LA006Accident · Serious injuriesClass 3 · LimitedFinal reportNanchang China CJ 6 · Buckeye, AZThe failure of the fuel pump’s diaphragm which resulted in fuel system contamination from air and or oil and caused the engine to lose power.Oct 9, 2017 · N8NW · Substantial damageNTSB CEN18LA012Accident · 1 fatalLimited investigationFinal reportGlobe GC 1A · Los Lunas, NMThe loss of directional control during takeoff and impact with a steel culvert.Oct 9, 2017 · N90365 · Substantial damageNTSB GAA18CA008Accident · No injuriesData collectionFinal reportCessna 150 · Medina, OHThe student pilot’s improper landing flare, which resulted in a hard landing and porpoise.Oct 8, 2017 · N7313G · Substantial damageNTSB GAA18CA005Accident · No injuriesData collectionFinal reportCessna 172 · Black River Falls, WIThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Oct 8, 2017 · N9664Q · Substantial damageNTSB CEN18FA004Accident · 1 fatalField investigationFinal reportAero Vodochody L39C · Vernon, TXAn in-flight loss of control and collision with terrain for reasons that could not be determined based on the available information.Oct 8, 2017 · N580LL · DestroyedNTSB GAA18CA007Accident · No injuriesData collectionFinal reportCessna T210 · Waterford, MIThe pilot's unstabilized approach at night, which resulted in collision with trees.Oct 7, 2017 · N5EC · Substantial damageNTSB GAA18CA006Accident · No injuriesData collectionFinal reportMaule M 7 · Manokatak, AKThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions.Oct 7, 2017 · N81818 · Substantial damageNTSB GAA18CA004Accident · Minor injuriesData collectionFinal reportMooney M20 · Topping, VAThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a departure stall.Oct 7, 2017 · N7884V · Substantial damageNTSB CEN18LA006Accident · Serious injuriesLimited investigationFinal reportCameron N-105 · Albuquerque, NMThe steep approach and hard landing after the balloon encountered unexpected high wind conditions, which resulted in a serious injury to a passenger.Oct 7, 2017 · N29922 · No damageNTSB GAA18CA016Accident · Serious injuriesData collectionFinal reportUltramagic T210 · Albuquerque, NMThe pilot's failure to maintain adequate clearance from a balloon on the ground during landing.Oct 6, 2017 · N123UT · 2 aircraft · Substantial damageNTSB ERA18LA007Accident · No injuriesLimited investigationFinal reportErcoupe 415 · Centre Hall, PAThe partial loss of engine power due to the No. 2 cylinder exhaust valve being stuck.Oct 6, 2017 · N3538H · Substantial damageNTSB CEN18LA010Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Sweetwater, TXThe loss of engine power during a precautionary approach for landing for reasons that could not be determined based on the available information.Oct 6, 2017 · N8234R · Substantial damageNTSB WPR18LA005Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 24-250 · Hillsboro, ORThe student's pilot’s failure to maintain adequate airspeed during approach and subsequent exceedance of the critical angle of attack during a go-around, which resulted in an aerodynamic stall and a subsequent hard landing. Contributing to the accident was…Oct 5, 2017 · N7892P · Substantial damageNTSB ERA18FA005Accident · 1 fatalField investigationFinal reportBryant C Crosby BC Ultra PUP · Bardstown, KYThe pilot's improper decision to initiate a flight in an airplane he had never flown and with no currency in any airplane nor a medical certificate, which resulted in his loss of airplane control. Contributing to the accident was the pilot's psychiatric…Oct 5, 2017 · N484HC · Substantial damageNTSB ERA18FA004Accident · 2 fatalField investigationFinal reportCessna 401 · Salters, SCThe pilot's decision to attempt a low-altitude aerobatic maneuver in a non-aerobatic airplane, and his subsequent failure to maintain control of the airplane during the maneuver. Contributing to the accident was the pilot's impairment by the effects of…Oct 4, 2017 · N401HH · DestroyedNTSB CEN18FA003Accident · 1 fatalField investigationFinal reportSchaffer Fisher Horizon 2 · Eden Prairie, MNAn inflight loss of control and collision with terrain for undetermined reasons after a thorough examination of the airplane's flight controls was unable to confirm control continuity. Contributing to the accident was the pilot's lack of experience in the…Oct 4, 2017 · N428AP · DestroyedNTSB WPR18LA018Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Blythe, CAMaintenance personnel's failure to properly torque an oil supply line fitting, which resulted in oil starvation, a subsequent engine failure, and an off-airport landing.Oct 3, 2017 · N418CP · Substantial damageNTSB GAA18CA001Accident · No injuriesData collectionFinal reportPiper J3C · Yakima, WAThe flight instructor's failure to maintain directional control during the takeoff roll.Oct 3, 2017 · N48694 · Substantial damageNTSB ERA18LA003Accident · Minor injuriesClass 3 · LimitedFinal reportFreeman Heritage Collection SE5A · Virginia Beach, VAA partial loss of engine power due to an interruption of the normal fuel/air mixture to the engine.Oct 3, 2017 · N685SE · Substantial damageNTSB WPR18LA002Accident · No injuriesLimited investigationFinal reportCessna 172S · Tonopah, NVThe pilot's failure to enrich the mixture during the descent, as required by the Pilot's Operating Handbook (POH), and his subsequent failure to follow the POH emergency procedures, which resulted in an excessively lean fuel/air mixture and subsequent loss of…Oct 2, 2017 · N5311H · Substantial damageNTSB ERA18LA002Accident · 1 fatalLimited investigationFinal reportCessna 182 · San Juan, PRThe pilot's failure to maintain adequate distance from helicopters during the approach for landing, resulting in an encounter with wake turbulence and subsequent loss of control.Oct 2, 2017 · N9021X · Substantial damageNTSB DCA18CA001Accident · No injuriesData collectionFinal reportBoeing 737 7H4 · Chicago, ILthe mechanical failure of the tugs fuel governor, which made it difficult for the ramp agent to stop the tug. Contributing to the accident was the lack of guidance on how ground personnel were to handle vehicle malfunctions.Oct 2, 2017 · N930WN · Substantial damageNTSB GAA18CA021Accident · Minor injuriesData collectionFinal reportPiper PA32R · Block Island, RIThe pilot's use of an incorrect airspeed during landing, which resulted in a runway overrun.Oct 1, 2017 · N1054S · DestroyedNTSB CEN18FA001Accident · 1 fatalField investigationFinal reportBrantly B 2B · Midland, MIThe pilot's failure to maintain control of the helicopter, which resulted in a loss of tail rotor effectiveness, and his failure to promptly initiate the proper recovery technique, which resulted in a descent that could not be arrested before impacting the…Oct 1, 2017 · N2284U · Substantial damageNTSB GAA17CA566Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Hampshire, ILThe pilot’s improper landing flare and subsequent failure to maintain directional control during landing.Sep 30, 2017 · N260BA · Substantial damageNTSB GAA17CA581Accident · No injuriesData collectionFinal reportCessna 414 · San Jose, CAThe pilot’s failure to maintain a proper descent rate, which resulted in a hard landing.Sep 29, 2017 · N1652T · Substantial damageNTSB CEN17CA371Accident · No injuriesData collectionFinal reportVans RV7 · Itasca, TXThe pilot’s inadequate preflight planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.Sep 29, 2017 · N712RL · Substantial damageNTSB GAA17CA575Accident · No injuriesData collectionFinal reportSilvaire 8 · Texarkana, ARThe pilot’s failure to maintain directional control during the landing roll.Sep 28, 2017 · N9902C · Substantial damageNTSB GAA17CA563Accident · No injuriesData collectionFinal reportPiper PA 22 · Orangeburg, SCA failed main landing gear tire for reasons that could not be determined due to postcrash fire damage.Sep 28, 2017 · N4734Z · DestroyedNTSB ERA17LA341Accident · No injuriesLimited investigationFinal reportCessna 162 · Huntsville, ALThe flight instructor’s failure to use carburetor heat, which resulted in the total loss of engine power due to carburetor icing.Sep 28, 2017 · N552ES · Substantial damageNTSB ERA17LA340Accident · Minor injuriesLimited investigationFinal reportWaco UPF 7 · Ocklawaha, FLA failure of both magnetos due to multiple deficiencies, which resulted in a total loss of engine power.Sep 28, 2017 · N29909 · Substantial damageNTSB ERA17FA339Accident · 1 fatalField investigationFinal reportHickox Andy Andys Gyroplane · Umatilla, FLThe pilot's improper response to a total loss of engine power, which resulted in main rotor blade contact with the rudder and vertical stabilizer, and a subsequent uncontrolled descent. The loss of engine power was due to the separation of the electrical…Sep 28, 2017 · N152AH · DestroyedNTSB CEN17LA372Accident · No injuriesLimited investigationFinal reportPiper PA 25-235 · Westphalia, KSA total loss of engine power due to a fatigue failure of the crankshaft that resulted from main bearing shift and lack of lubrication.Sep 28, 2017 · N7336Z · Substantial damageNTSB GAA17CA572Accident · No injuriesData collectionFinal reportCub Crafters CC19-180 · Kalispell, MTThe pilot’s inadvertent brake application during the landing roll, which resulted in a loss of directional control.Sep 27, 2017 · N53XC · Substantial damageNTSB GAA17CA562Accident · Minor injuriesData collectionFinal reportEurocopter AS 350 · Fullerton, CAThe pilot under evaluation’s failure to maintain adequate airspeed during a simulated hydraulic failure, which resulted in a loss of helicopter control. Contributing to the accident was the check pilot’s delayed remedial action.Sep 27, 2017 · N515ET · Substantial damageNTSB GAA17CA561Accident · No injuriesData collectionFinal reportAmerican Legend AL18 · Bessemer, ALThe student pilot’s incorrect application of the brakes and subsequent failure to maintain directional control during the landing roll. Contributing to the accident was the flight instructor’s delayed remedial action.Sep 27, 2017 · N200XW · Substantial damageNTSB GAA17CA560Accident · Minor injuriesData collectionFinal reportPiper J5A · Geneseo, NYThe pilot's failure to properly secure the airplane before a hand propeller start, which resulted in the airplane moving forward and colliding with maintenance equipment.Sep 27, 2017 · N38633 · Substantial damageNTSB GAA17CA559Accident · No injuriesData collectionFinal reportCessna 182 · San Diego, CAThe airplane’s inadvertent entry into instrument meteorological, dark night conditions and the pilot’s failure to maintain an adequate approach for landing.Sep 27, 2017 · N9346G · Substantial damageNTSB ERA17LA336Accident · No injuriesLimited investigationFinal reportCessna 152 · Winder, GAThe pilot's inadequate preflight inspection, which resulted in undetected water in the fuel system and a total loss of engine power during the initial climb.Sep 27, 2017 · N53393 · Substantial damageNTSB WPR17LA217Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Los Angeles, CAThe pilot's failure to extend the landing gear before landing.Sep 26, 2017 · N9020P · Substantial damageNTSB GAA17CA557Accident · Minor injuriesData collectionFinal reportBellet James J Vans RV 8 · Orange, MAThe pilot's failure to remove the engine cowl plugs during preflight, which resulted in excessive engine cylinder head temperatures during climb and a total loss of engine power.Sep 26, 2017 · N184SJ · Substantial damageNTSB WPR17LA216Accident · No injuriesLimited investigationFinal reportCessna 172P · TamuningThe pilot's inadequate preflight inspection, which resulted in oil exhaustion and a subsequent total loss of engine power during cruise flight.Sep 25, 2017 · N5448K · Substantial damageNTSB GAA17CA569Accident · No injuriesData collectionFinal reportPiper PA 18 · Beluga, AKThe pilot’s inability to maintain pitch control due to an encounter with a tailwind gust after the airplane had stopped, which resulted in a nose-over.Sep 25, 2017 · N3797Z · Substantial damageNTSB ERA17LA335Accident · Minor injuriesClass 3 · LimitedFinal reportBrad J Bates Mosquito XE 285 · Odessa, FLA total loss of engine power due to cold seizure of the No.1 piston, which resulted in its failure and a subsequent emergency autorotation and impact with a house’s roof.Sep 25, 2017 · N926KB · Substantial damage