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 ERA20FA009Accident · 1 fatalClass 3 · FieldFinal reportVans RV4 · Cameron, NCThe pilot's exceedance of the airplane’s critical angle of attack during the landing approach, which resulted in a loss of control and a subsequent aerodynamic stall/spin. Contributing to the accident was the pilot's decision to fly the airplane in a…Oct 14, 2019 · N4332J · Substantial damageNTSB GAA20CA015Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Goddard, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.Oct 13, 2019 · N96709 · Substantial damageNTSB ANC20LA002Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Palmer, AKThe pilot's delayed application of carburetor heat in weather conditions conducive to carburetor icing, which resulted in a partial loss of engine power, a precautionary landing, and impact with terrain.Oct 13, 2019 · N7267A · Substantial damageNTSB ANC20CA006Accident · No injuriesData collectionFinal reportPiper PA18 · Moose Pass, AKThe pilot's improper approach, which resulted in his failure to maintain clearance from a tree while landing in dusk conditions, and his subsequent loss of directional control, which resulted in a runway excursion.Oct 13, 2019 · N645DT · Substantial damageNTSB GAA20CA026Accident · Minor injuriesData collectionFinal reportLlewellyn, Warwinc W Vans RV-4 · Lusby, MDThe pilot's failure to maintain lateral control during takeoff, which resulted in impact with terrain and a subsequent cartwheel.Oct 12, 2019 · N15WL · Substantial damageNTSB GAA20CA024Accident · No injuriesData collectionFinal reportCessna 180 · Greenville, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and ground-loop.Oct 12, 2019 · N333DW · Substantial damageNTSB CEN20TA007Accident · Serious injuriesFinal reportAutoGyro MTO Sport · Montgomery, TXThe pilot's failure to maintain clearance from trees during departure. Contributing to the accident was the pilot's inadequate preflight assessment of the field for takeoff.Oct 12, 2019 · N498AG · Substantial damageNTSB GAA20CA027Accident · Minor injuriesData collectionFinal reportZenith Zenith 601XLB · Gastonia, NCThe pilot's failure to latch the canopy before departure, which resulted in the canopy opening and the subsequent loss of airplane control.Oct 11, 2019 · N235JH · Substantial damageNTSB GAA20CA019Accident · Serious injuriesData collectionFinal reportAntares MA33 · Coeur d'Alene, IDThe student pilot's improper release of the throttle and failure to maintain lateral control during takeoff.Oct 11, 2019 · N92287 · Substantial damageNTSB GAA20CA018Accident · Serious injuriesData collectionFinal reportFoxworthy Rick A Sonex · Langley, WAThe pilot's failure to maintain a proper approach path, which resulted in impact with a tree.Oct 11, 2019 · N612RF · Substantial damageNTSB GAA20CA017Accident · No injuriesData collectionFinal reportPiper PA28 · Dayton, OHThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing, during which the airplane struck a vehicle.Oct 10, 2019 · N8078X · Substantial damageNTSB GAA20CA009Accident · No injuriesData collectionFinal reportAeronca 7AC · Waynesburg, PAThe student pilot's failure to maintain directional control during the landing roll due to his foot slipping off the right pedal and becoming stuck between the pedal and fuselage frame, which resulted in a runway excursion and impact with a ditch.Oct 10, 2019 · N2343E · Substantial damageNTSB WPR20FA005Accident · 1 fatalClass 3 · FieldFinal reportBede BD5 · Camarillo, CAThe No. 4 connecting rod’s bearing shift and separation of the No. 4 connecting rod, which resulted in a total loss of engine power and subsequent forced landing.Oct 8, 2019 · N501BD · Substantial damageNTSB GAA20CA010Accident · No injuriesData collectionFinal reportCessna 150 · Fallon, NVThe pilot's improper preflight fuel planning and quantity inspection, which resulted in fuel exhaustion, a total loss of engine power, a forced landing on unsuitable terrain, and a subsequent nose-over.Oct 8, 2019 · N50618 · Substantial damageNTSB ERA20LA008Accident · No injuriesClass 3 · LimitedFinal reportRaytheon Hawker · Fort Myers, FLMaintenance personnel's improper installation of the nose landing gear assembly, which resulted in separation of the actuator arm and the failure of a nose landing gear to lock in place.Oct 8, 2019 · N86MN · Substantial damageNTSB CEN20LA006Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Waukesha, WIA total loss of engine power for undetermined reasons.Oct 8, 2019 · N396JG · Substantial damageNTSB GAA20CA012Accident · Minor injuriesData collectionFinal reportAerostar International RX 7 · Rio Rancho, NMThe pilot's failure to maintain an adequate descent rate during landing, which resulted in a hard landing and a postaccident fire.Oct 7, 2019 · N9126K · DestroyedNTSB GAA20CA007Accident · No injuriesData collectionFinal reportDe Havilland Beaver DHC 2 · Kodiak, AKThe pilot's failure to maintain lateral control while landing on glassy water, which resulted in the left float touching the water, a loss of yaw control, and impact with a riverbank.Oct 7, 2019 · N1544 · Substantial damageNTSB ERA20LA006Accident · No injuriesClass 3 · LimitedFinal reportHonda HA-420 · Charleston, SCGround personnel’s use of an improper towbar adapter lug, which prevented the nose landing gear from extending.Oct 7, 2019 · N166HJ · Substantial damageNTSB WPR20LA004Accident · Minor injuriesClass 3 · LimitedFinal reportGlaser Dirks DG500 · Marana, AZThe pilots’ exceedance of the glider’s never-exceed speed (VNE) during recovery from an intentional aerobatic maneuver, which resulted in a failure of the right-wing air brake control drive, asymmetrical air brake deployment, and a subsequent hard landing.Oct 6, 2019 · N600TT · Substantial damageNTSB CEN20LA004Accident · No injuriesClass 3 · LimitedFinal reportBeech B36 · Ranger, TXA lack of climb performance after takeoff for reasons that could not be determined based on the available information.Oct 6, 2019 · N36LS · Substantial damageNTSB CEN20FA003Accident · 1 fatalClass 3 · FieldFinal reportLancair Legacy · Bixby, MOThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.Oct 6, 2019 · N10LG · Substantial damageNTSB WPR20LA001Accident · 1 fatalClass 3 · LimitedFinal reportBuckeye Breeze · Moore, UTThe pilot’s improper preflight inspection and detection of a pinch point in the steering line, which resulted in a loss of control in flight and impact with terrain.Oct 5, 2019 · N582UT · Substantial damageNTSB GAA20CA006Accident · Minor injuriesData collectionFinal reportCessna 172 · Kaplan, LAThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and impact with a pole during an off-airport landing.Oct 5, 2019 · N7871U · Substantial damageNTSB GAA20CA005Accident · No injuriesData collectionFinal reportPavel Vagner Tango · Dublin, TXThe pilot's improper landing flare and failure to maintain lateral control, which resulted in a hard landing, loss of directional control, and subsequent roll-over.Oct 5, 2019 · N8445P · Substantial damageNTSB GAA20CA004Accident · No injuriesData collectionFinal reportReed Mike Smiths Super CUB · Triangle, IDThe pilot's excessive use of brakes during the landing roll, which resulted in a nose-over.Oct 5, 2019 · N677M · Substantial damageNTSB ERA20FA002Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Asheboro, NCThe pilot’s loss of airplane control due to spatial disorientation, which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of recent night flight experience.Oct 5, 2019 · N2FB · DestroyedNTSB CEN20FA002Accident · 1 fatalClass 3 · FieldFinal reportPiper Aerostar 602P · Kokomo, INThe pilot's exceedance of the airplane’s critical angle of attack following a dual engine power loss caused by the line service technician fueling the airplane with the wrong fuel, which resulted in an aerodynamic stall and subsequent loss of control.…Oct 5, 2019 · N326CW · DestroyedNTSB ERA20TA005Accident · No injuriesClass 3Final reportSilverlight AR-1 · Fort Meade, FLThe student pilot’s inadequate preflight inspection that failed to detect water contamination of the fuel and resulted in a total loss of engine power during cruise flight.Oct 3, 2019 · N463JW · Substantial damageNTSB ERA20LA004Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58A · Fort Meade, FLThe pilot's failure to maintain control of the helicopter, which resulted in a dynamic rollover and impact with terrain.Oct 3, 2019 · N911RW · Substantial damageNTSB CEN20FA001Accident · 5 fatalClass 3 · FieldFinal reportSocata TBM 700 · Lansing, MIThe pilot’s failure to maintain airspeed during final approach, which resulted in a loss of control and an aerodynamic stall at a low altitude, and his decision to operate the airplane outside of the approved weight and balance envelope.Oct 3, 2019 · N700AQ · Substantial damageNTSB GAA20CA002Accident · No injuriesData collectionFinal reportRobinson R44 · Carlsbad, CAThe student pilot's incorrect collective and cyclic applications during landing and the flight instructor's delayed remedial action, which resulted in a roll-over.Oct 2, 2019 · N4050X · Substantial damageNTSB ERA20MA001Accident · 7 fatalClass 2 · MajorFinal reportBoeing B17 · Windsor Locks, CTThe pilot’s failure to properly manage the airplane’s configuration and airspeed after he shut down the No. 4 engine following its partial loss of power during the initial climb. Contributing to the accident was the pilot/maintenance director’s inadequate…Oct 2, 2019 · N93012 · DestroyedNTSB GAA20CA001Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Longs, SCThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, an off-airport landing, and impact with trees.Oct 1, 2019 · N95131 · Substantial damageNTSB ERA20LA052Accident · No injuriesClass 3 · LimitedFinal reportBeech 55 · Grove City, PAThe pilot’s mismanagement of the airplane’s available fuel, which resulted in a partial loss of engine power to the left engine, and his subsequent failure to maintain directional control of the airplane while on final approach to the runway.Oct 1, 2019 · N9404Q · Substantial damageNTSB ERA19FA283Accident · 3 fatalClass 3 · FieldFinal reportCessna 421 · Deland, FLThe pilot’s failure to maintain control of the airplane, which resulted in a collision with terrain. Contributing was the pilot’s lack of training and experience in the accident airplane make and model.Sep 29, 2019 · N731PF · DestroyedNTSB GAA19CA582Accident · No injuriesData collectionFinal reportDiamond DA 40 · Mesa, AZThe pilot's decision to abort a go-around with insufficient runway remaining to safely stop the airplane, which resulted in a loss of control, runway excursion and impact with a concrete barrier.Sep 28, 2019 · N4119S · Substantial damageNTSB GAA19CA577Accident · No injuriesData collectionFinal reportPitts S2 · Morrisville, VTThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and nose down.Sep 28, 2019 · N5310S · Substantial damageNTSB ERA19LA287Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R44 · Sanford, METhe student pilot's failure to maintain helicopter control while hover-taxiing in gusting wind conditions.Sep 28, 2019 · N21EH · Substantial damageNTSB ERA19LA286Accident · 1 fatalLimited investigationFinal reportSolo Wings Windlass · Dalton, GAThe pilot's exceedance of the aircraft's critical angle of attack during a turn shortly after takeoff, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing was the pilot's lack of experience in the accident aircraft.Sep 28, 2019 · UNREG · Substantial damageNTSB ERA19LA285Accident · Serious injuriesClass 3 · LimitedFinal reportEnstrom F28 · Bloomsburg, PAThe pilot's failure to maintain proper forward airspeed and power during final approach, which resulted in a loss of tail rotor effectiveness and impact with terrain.Sep 28, 2019 · N380SH · Substantial damageNTSB WPR19FA266Accident · 2 fatalClass 3 · FieldFinal reportAmerican AA5 · Cowles, NMThe pilot's decision to fly into terrain that exceeded the performance capabilities of the airplane, which resulted in failure to maintain clearance from trees and terrain.Sep 27, 2019 · N9774U · DestroyedNTSB GAA19CA586Accident · No injuriesData collectionFinal reportPiper PA 12 · Williams, CAThe pilot's over application of power during recovery from a runway excursion, which resulted in a ground loop and nose over.Sep 27, 2019 · N3985M · Substantial damageNTSB GAA19CA576Accident · No injuriesData collectionFinal reportPiper PA 22 · Pollock, LAThe pilot's improper landing flare, which resulted in a bounced landing and subsequent ground loop.Sep 27, 2019 · N3365B · Substantial damageNTSB CEN19LA334Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Columbus, MSA total loss of engine power control for undetermined reasons.Sep 27, 2019 · N801BF · Substantial damageNTSB GAA19CA575Accident · Minor injuriesData collectionFinal reportPiper J3C · Lander, WYThe pilot's failure to maintain lateral control during takeoff with a quartering tailwind, which resulted in the right wing striking the ground, a runway excursion, impact with a fence, and a subsequent noseover.Sep 26, 2019 · N33463 · Substantial damageNTSB ANC19TA055Accident · Serious injuriesClass 4Final reportStinson 108 · Tyonek, AKThe pilot’s exceedance of the airplane’s critical angle of attack during a short field takeoff, which resulted in an aerodynamic stall and loss of control.Sep 26, 2019 · N6533M · Substantial damageNTSB GAA19CA590Accident · No injuriesData collectionFinal reportCessna 172 · St. Augustine, FLThe student pilot's improper landing flare, which resulted in a bounced, hard landing.Sep 25, 2019 · N309BR · Substantial damageNTSB GAA19CA587Accident · No injuriesData collectionFinal reportBeech 36 · Lubbock, TXThe pilot's improper pitch trim setting during takeoff in a left quartering tailwind, which resulted in the airplane abruptly pitching up and subsequently experiencing an aerodynamic stall. Contributing to the accident was the pilot's failure to follow a…Sep 25, 2019 · N5836B · Substantial damageNTSB GAA19CA571Accident · No injuriesData collectionFinal reportCessna 152 · Lafayette, INThe student pilot's improper landing flare, which resulted in a bounced landing and subsequent nose landing gear collapse.Sep 25, 2019 · N6450B · Substantial damage