NTSB investigations

19,008 cases where NTSB found Personnel issues.

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\", '02'))
  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 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 GAA20CA008Accident · No injuriesData collectionFinal reportPiper PA18 · Big Flats, NYThe pilot's improper flight planning and his subsequent failure to maintain clearance from wires during takeoff.Oct 10, 2019 · N4138Z · Substantial damageNTSB CEN20FA010Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Aberdeen, SDThe noncertificated pilot’s decision to fly in dark night instrument conditions, resulting in impact with terrain.Oct 10, 2019 · N6483B · DestroyedNTSB GAA20CA042Accident · No injuriesData collectionFinal reportBeech 19 · Somerville, TNThe pilot's failure to move the fuel selector position to the "on" position before takeoff, which resulted in a total loss of engine power and necessitated a forced landing to a field shortly after takeoff, and his subsequent improper decision to take off…Oct 9, 2019 · N2177W · 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 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 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 ERA20FA003Accident · Serious injuriesClass 3 · FieldFinal reportChampion 7ECA · Pembroke Pines, FLThe pilot’s failure to relinquish the airplane controls to the instructor during a power-off stall maneuver, which prevented the instructor’s recovering from the stall.Oct 5, 2019 · N2561G · 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 GAA20CA003Accident · No injuriesData collectionFinal reportVans RV9 · Lake Elsinore, CAThe pilot's selection of unsuitable terrain for taxi, which resulted in the landing gear collapsing and a nose-over.Oct 4, 2019 · N192DP · Substantial damageNTSB 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 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 damageNTSB GAA19CA570Accident · Serious injuriesData collectionFinal reportCirrus SR22 · Lexington, NEThe pilot's exceedance of the airplane's critical angle of attack during a go around, which resulted in an aerodynamic stall and a hard landing.Sep 25, 2019 · N1216N · Substantial damageNTSB CEN19TA333Accident · No injuriesClass 3Final reportLancair Lancair 320 · Bolivar, MOInadequate maintenance of the airplane, which resulted in a lack of adequate hydraulic fluid, malfunction of the landing gear extension system, and the landing gear collapse on landing.Sep 25, 2019 · N52WL · Substantial damageNTSB WPR19LA265Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Gresham, ORA total loss of engine power due to fuel starvation as a result of the instructor’s inadequate in-flight fuel management.Sep 24, 2019 · N5277C · Substantial damageNTSB GAA19CA591Accident · Serious injuriesData collectionFinal reportCessna 182 · Elizabethtown, NCThe pilot's improper landing flare, which resulted in a hard landing and postaccident fire. Contributing to the accident was the pilot’s distraction during short final.Sep 24, 2019 · N101SD · DestroyedNTSB ERA19LA282Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 337 · St. Augustine, FLThe failure of the pilot and examiner to recognize that the rear engine was not developing power, which resulted in an attempted partial-power takeoff and the airplane’s subsequent descent and impact with terrain.Sep 24, 2019 · N108LS · Substantial damageNTSB CEN19FA332Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Prairie Grove, ARThe noninstrument-rated pilot's loss of control due to spatial disorientation after encountering instrument meteorological conditions at night.Sep 24, 2019 · N4658X · Substantial damageNTSB GAA19CA580Accident · No injuriesData collectionFinal reportCessna 172 · Plant City, FLThe student pilot's failure to maintain directional control during the aborted landing, which resulted in a runway excursion and impact with a ditch.Sep 23, 2019 · N739RT · Substantial damageNTSB GAA19CA572Accident · No injuriesData collectionFinal reportPiper PA18 · Boulder, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Sep 23, 2019 · N4785F · Substantial damageNTSB GAA19CA567Accident · No injuriesData collectionFinal reportGeorge W. Felix Mosquito · Kershaw, SCThe pilot's improper cyclic input during takeoff, which resulted in a loss of helicopter control, the skid impacting the ground, and a subsequent dynamic rollover.Sep 23, 2019 · N849GF · Substantial damageNTSB GAA19CA564Accident · No injuriesData collectionFinal reportPiper PA18 · Skwentna, AKThe pilot's improper decision to depart from an off-airport surface covered with standing water, which resulted in a noseover.Sep 23, 2019 · N5408Y · Substantial damage