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 ERA23LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 150H · Mattituck, NYThe pilot’s failure to maintain control of the airplane during the landing, which resulted in a hard landing and runway excursion.Mar 27, 2023 · N50133 · Substantial damageNTSB CEN23LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · Oklahoma City, OKThe pilot’s improper landing flare, which resulted in a hard, bounced landing, runway excursion, and subsequent collision with a runway sign. Contributing to the accident was the pilot’s lack of experience in the airplane, the unstabilized approach, and…Mar 27, 2023 · N550DW · Substantial damageNTSB CEN23LA146Accident · No injuriesClass 4 · LimitedFinal reportBeech 35 · Telluride, COThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.Mar 27, 2023 · N3233V · Substantial damageNTSB ERA23LA165Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · St. Augustine, FLThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion and an impact with a ditch.Mar 26, 2023 · N541SP · Substantial damageNTSB CEN23FA142Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Port Allen, LAThe pilot’s decision to continue the visual flight rules flight into deteriorating weather conditions, which resulted in spatial disorientation and the loss of aircraft control.Mar 26, 2023 · N441PD · DestroyedNTSB ERA23FA164Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Johns Island, SCThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the pilot’s degraded judgement and…Mar 25, 2023 · N21480 · Substantial damageNTSB ERA23FA163Accident · 1 fatalClass 3 · FieldFinal reportLarry F Preiss AR-1 · Gainesville, GAThe pilot's inadequate preflight inspection and his failure to detect water-contaminated fuel that resulted in a loss of engine power and subsequent impact with a wire and terrain during an attempted forced landing.Mar 25, 2023 · N47AR · Substantial damageNTSB CEN23LA143Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Hillsboro, MOThe pilot’s failure to maintain clearance from trees during final approach to landing.Mar 25, 2023 · N43272 · Substantial damageNTSB WPR23LA236Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Springfield, KYThe pilot’s failure to activate the pitot heat in a timely manner during flight into icing conditions, which resulted in a temporary failure of the flight instruments and a subsequent loss of control.Mar 24, 2023 · N146MS · Substantial damageNTSB ANC23FA031Accident · 2 fatalClass 3 · FieldFinal reportBell Helicopter Textron 407 · Nuevo, CAThe pilot’s decision to maneuver in a steep bank at a low altitude, which resulted in his failure to maintain clearance with terrain.Mar 24, 2023 · N14Z · DestroyedNTSB ERA23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Travelers Rest, SCMaintenance personnel’s improper servicing of the magneto, which resulted in its accelerated wear, failure, and the total loss of engine power.Mar 23, 2023 · N13612 · Substantial damageNTSB ERA23LA161Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-46-350P · St. Augustine, FLThe pilot's inadequate preflight planning, which resulted in a takeoff above the airplane’s maximum gross weight, a CG forward of the limit, and a tailwind component that prevented the airplane from climbing above trees.Mar 23, 2023 · N280KC · DestroyedNTSB ERA23LA198Accident · No injuriesClass 3 · LimitedFinal reportS C Aerostar S A YAK-52 · Toughkenamon, PAThe pilot’s failure to see and avoid powerlines while on approach to land.Mar 22, 2023 · N669YK · Substantial damageNTSB ERA23LA179Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18AS-125 · Lakeland, FLThe pilot’s failure to ensure that the landing gear was properly configured for a water landing.Mar 22, 2023 · N1907A · Substantial damageNTSB DCA23LA221Accident · No injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Houston, TXThe first officer's failure to maintain the correct airspeed and pitch attitude during landing which resulted in a tailstrike.Mar 22, 2023 · N1902U · Substantial damageNTSB WPR23FA137Accident · 1 fatalClass 3 · FieldFinal reportCessna 182S · Alcova, WYThe airplane’s encounter with low level wind shear associated with moderate turbulence, which resulted in a loss of airplane control.Mar 21, 2023 · N314FR · Substantial damageNTSB ERA23LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Cincinnati, OHThe pilot’s failure to maintain an adequate visual lookout during taxi, which resulted in a collision with a parked airplane. Contributing was the marshaller’s improper marshalling techniques.Mar 21, 2023 · N7772B · Substantial damageNTSB ERA23LA157Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-2A-1 · Livonia, NYThe pilot’s delayed action to arrest the high descent rate during a practice autorotation in tailwind conditions which ultimately resulted in loss of control.Mar 21, 2023 · N73905 · Substantial damageNTSB ERA23LA160Accident · Serious injuriesClass 4 · LimitedFinal reportMaule M-7-235C · Abbeville, SCA loss of directional control during landing, which resulted in a ground loop and substantial damage to the airplane. The pilot flying could not be determined since both pilots claimed that the other was at the controls during the landing. The flight…Mar 20, 2023 · N79VE · Substantial damageNTSB ERA23LA155Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Sanford, NCA loss of directional control while landing, which resulted in a runway excursion and impact with a ditch.Mar 19, 2023 · N565TF · Substantial damageNTSB CEN23LA141Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Maple Lake, MNThe student pilot’s failure to maintain directional control during landing with a gusting crosswind.Mar 19, 2023 · N9088D · Substantial damageNTSB CEN23LA140Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Oklahoma City, OKThe pilot’s loss of directional control during landing with wind gusts, which resulted in a runway excursion and nose over.Mar 19, 2023 · N9254A · Substantial damageNTSB WPR23LA131Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-4-220C · Santa Ynez, CAThe pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel starvation.Mar 18, 2023 · N40635 · Substantial damageNTSB WPR23LA133Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Winnemucca, NVThe student pilot’s failure to maintain directional control, and the flight instructor’s delayed remedial action.Mar 17, 2023 · N326AF · Substantial damageNTSB WPR23LA132Accident · No injuriesClass 4 · LimitedFinal reportFay David Velocity Elite · Bullhead City, AZThe student pilot’s improper landing during crosswind conditions and the flight instructor’s failure to take remedial action, which resulted in a loss of control.Mar 17, 2023 · N2214W · Substantial damageNTSB WPR23LA129Accident · Serious injuriesClass 4 · LimitedFinal reportNavion Navion A · Mesa, AZThe pilot of the Ryan Navion’s failure to maintain visual sight of and clearance from another airplane during a formation flight, which resulted in a mid-air collision.Mar 17, 2023 · N610 · 2 aircraft · Substantial damageNTSB CEN23FA139Accident · 1 fatalClass 3 · FieldFinal reportBeech 58P · Lubbock, TXThe pilot’s failure to ensure a proper fuel selector position before takeoff, which resulted in a loss of left engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to maintain airplane control after the loss of left engine…Mar 17, 2023 · N2061K · DestroyedNTSB WPR23LA136Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Spanish Fork, UTThe retraction of the main landing gear for undetermined reasons.Mar 15, 2023 · N2572V · Substantial damageNTSB ERA23LA151Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 35-B33 · Scottsmoor, FLThe pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion.Mar 14, 2023 · N5714K · Substantial damageNTSB CEN23LA132Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235B · Hotchkiss, COThe pilot’s loss of control during landing rollout on a snow-covered, turf airstrip.Mar 13, 2023 · N235TT · Substantial damageNTSB WPR23LA139Accident · No injuriesClass 4 · LimitedFinal reportFiedler Mark R PA-18 Replica · Sandy Valley, NVThe pilot’s failure to maintain airplane control during an off airport precautionary landing on soft soil, which resulted in a nose over.Mar 12, 2023 · N127MF · Substantial damageNTSB ERA23LA149Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 · Church Hill, MDThe student pilot’s failure to maintain airplane control during the landing attempt and the flight instructor’s inadequate remedial action.Mar 12, 2023 · N562TU · Substantial damageNTSB CEN23LA138Accident · Serious injuriesClass 4 · LimitedFinal reportSocata TB21 · Eden Prairie, MNThe pilot’s continued flight into icing conditions in an airplane that was not equipped for icing, which led to structural icing, subsequent loss of airplane control and impact with terrain.Mar 12, 2023 · N789TB · DestroyedNTSB WPR23LA134Accident · No injuriesClass 3 · LimitedFinal reportHarris Robert W Zenith CH 801 · Brigham City, UTThe pilot’s improper flare, which resulted in a hard landing following a reported loss of engine thrust for undetermined reasons.Mar 11, 2023 · N639BH · Substantial damageNTSB WPR23LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Lewiston, IDThe flight instructor’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.Mar 11, 2023 · N7010Q · Substantial damageNTSB WPR23LA126Accident · Minor injuriesClass 4 · LimitedFinal reportTrendak Taurus · Strawberry Reservoir, UTThe pilot’s failure to maintain clearance from the snow-covered lake while flying at a low altitude.Mar 11, 2023 · N553AT · Substantial damageNTSB CEN23LA130Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · De Kalb, TXThe pilot’s inability to maintain control of the helicopter due to his failure to maintain rotor speed. Contributing to the accident was the failure of the helicopter’s low rotor speed warning system.Mar 11, 2023 · N4164T · Substantial damageNTSB WPR23LA124Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Van Nuys, CAThe pilots failure to maintain directional control during takeoff.Mar 10, 2023 · N73726 · Substantial damageNTSB CEN23LA128Accident · Minor injuriesClass 3 · LimitedFinal reportZenith Zodiac 601XL · La Veta, COThe pilot’s decision to fly the airplane in which he had no experience in strong, gusting wind, which resulted his failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.Mar 10, 2023 · N969WD · Substantial damageNTSB ERA23LA147Accident · Minor injuriesClass 4 · LimitedFinal reportEurocopter Deutschland EC 135 P2+ · Franklin, NCThe pilot’s improper decision to review an aircraft logbook while enroute, which resulted in controlled flight into terrain.Mar 9, 2023 · N558MT · Substantial damageNTSB ERA23LA146Accident · No injuriesClass 4 · LimitedFinal reportHughes 269A · Titusville, FLThe pilot’s failure to maintain adequate main rotor RPM during an autorotation which resulted in a hard landing and subsequent rotor blade strike of the tail boom.Mar 9, 2023 · N8911F · Substantial damageNTSB CEN23LA126Accident · No injuriesClass 4 · LimitedFinal reportBeech C90 · Bismark, NDThe ground vehicle driver’s failure to see and maintain clearance from the airplane while conducting ground operations.Mar 9, 2023 · N46CV · Substantial damageNTSB WPR23FA122Accident · 1 fatalClass 3 · FieldFinal reportRockwell International S-2R · Willows, CAThe pilot’s failure to maintain clearance from powerlines while flying under multiple conductors during a low-altitude aerial application flight, which resulted in propeller contact with a powerline and a subsequent loss of control.Mar 8, 2023 · N8424V · Substantial damageNTSB WPR23LA125Accident · Minor injuriesClass 4 · LimitedFinal reportRockwell International AC 690A · Bullhead City, AZThe pilot’s improper fuel planning for a cross-country flight, which resulted in fuel exhaustion, a total loss of engine power and subsequent impact with terrain.Mar 7, 2023 · N4PZ · Substantial damageNTSB WPR23LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Hillsboro, ORThe student pilot’s failure to see and avoid another airplane during taxi.Mar 7, 2023 · N25233 · 2 aircraft · Substantial damageNTSB WPR23FA143Accident · 1 fatalClass 3 · FieldFinal reportCessna T182T · Queets, WAThe pilot’s failure to maintain clearance from terrain for undetermined reasons.Mar 7, 2023 · N24289 · DestroyedNTSB ERA23LA145Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Knoxville, TNThe pilot's failure to maintain directional control during the takeoff roll where a gusting and shifting crosswind prevailed.Mar 7, 2023 · N320CA · Substantial damageNTSB ERA23FA142Accident · 4 fatalClass 3 · FieldFinal reportPiper J3C · Winter Haven, FLThe failure of both flight crews to see and avoid each other while operating in the airport environment.Mar 7, 2023 · N10510 · 2 aircraft · Substantial damageNTSB CEN23FA125Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Port O'Connor, TXThe pilot’s initiation of the visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of helicopter control. Contributing to the accident was the pilot’s flicker vertigo during the flight.Mar 7, 2023 · N494SH · DestroyedNTSB ANC23LA026Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Homer, AKThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop and impact with terrain.Mar 7, 2023 · N9697Q · Substantial damage