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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR16FA112Accident · 2 fatalField investigationFinal reportNorth American AT 6 · Mesa, AZThe pilot's inability to return to the departure airport due to an unspecified in-flight emergency for reasons that could not be determined during a postaccident examination of the airplane.NTSB GAA16CA245Accident · No injuriesData collectionFinal reportCessna 172 · Carbondale, ILThe student pilot's inadequate flare which resulted in a hard landing, loss of directional control, and a runway excursion.NTSB CEN16TA194Accident · No injuriesFinal reportNorth American AT6 · Mason, MIThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion and impact with a ditch.NTSB CEN16FA188Accident · 1 fatalField investigationFinal reportCessna P210N · Sheridan Lake, COThe pilot's severe impairment from the combined effects of high levels of ingested alcohol as well as three impairing medications (zolpidem, lorazepam, and diphenhydramine), which resulted in his decision to attempt an aerobatic maneuver that the airplane was…NTSB GAA16CA242Accident · Minor injuriesData collectionFinal reportVan B Anthony Zodiac · Grass Valley, CAThe pilot's failure to maintain a stabilized approach and landing, which resulted in a hard landing, loss of directional control, runway excursion, and collision with a parked airplane.NTSB ERA16FA186Accident · Serious injuriesField investigationFinal reportPiper PA28 · Homestead, FLThe pilot's improper decision to allow the passenger to attempt a landing, which resulted in a loss of control during landing with a quartering tailwind. Contributing to the severity of the pilot's injuries was the separation of the deteriorated shoulder…NTSB CEN16LA192Accident · No injuriesLimited investigationFinal reportCessna T206H · New Roads, LAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR16FA111Accident · 1 fatalField investigationFinal reportCessna R182 · Altadena, CAThe pilot's failure to maintain clearance from rising mountainous terrain while flying in instrument meteorological conditions. Contributing to the accident was the loss of radio communications for a reason that could not be determined because of the…NTSB GAA16CA244Accident · Minor injuriesData collectionFinal reportSchleicher ASW 19 · Frankton, INThe pilot's exceedance of the critical angle of attack on final approach in turbulent conditions, which resulted in an aerodynamic stall and collision with terrain.NTSB GAA16CA234Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Pahokee, FLThe pilot's failure to maintain directional control and lateral bank control during the aborted landing, which resulted in collision with terrain.NTSB GAA16CA233Accident · No injuriesData collectionFinal reportCessna 180 · St. George, UTThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, ground loop, right main landing gear collapse, and substantial damage to the right wing.NTSB CEN16LA186Accident · No injuriesLimited investigationFinal reportPiper PA 32R · Alpine, TXThe engine’s decreased performance due to high-density altitude conditions and a partially obstructed fuel injector nozzle. Contributing to the pilot's decision to perform an off-field landing was the anomalous high exhaust gas temperature reading.NTSB WPR16LA113Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Delano, CAThe student pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA16CA256Accident · No injuriesData collectionFinal reportCirrus Design SR20 · South St Paul, MNThe pilot's excessive nose high pitch attitude, which resulted in a tail strike during the landing flare.NTSB GAA16CA253Accident · No injuriesData collectionFinal reportCessna 172 · Shawnee, OKThe pilot's failure to remain a safe distance from obstacles while taxiing to parking, resulting in the airplane's wing striking a light pole.NTSB GAA16CA240Accident · No injuriesData collectionFinal reportMills Gregory T AIR Commander LRT · Tybee Island, GAThe pilot's decision to perform a touch-and-go on unsuitable terrain, which resulted in a loss of directional control and a rollover.NTSB GAA16CA235Accident · No injuriesData collectionFinal reportCessna 182P · Williamsburg, VAThe pilot's failure to maintain directional control during the landing in variable direction and gusting wind conditions, resulting in a landing off the side of the runway and impact with a drainage culvert.NTSB ERA16LA184Accident · Serious injuriesLimited investigationFinal reportGlobe GC 1B · Hedgesville, WVThe pilot's failure to maintain airplane control when it encountered a wind gust during climbout.NTSB ERA16FA182Accident · 1 fatalField investigationFinal reportGreg Connell Pitts S-2SW · Atlanta, GAThe pilot's failure to maintain proper positioning during performance of an aerobatic maneuver and his subsequent failure to discontinue maneuvering when unable to reestablish proper positioning during a steep descent toward the ground.NTSB CEN16LA181Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502 · West, TXThe pilot’s failure to see and avoid cellular tower guy wires. Contributing to the accident was the pilot’s decision to operate at low altitude.NTSB ANC16CA027Accident · No injuriesData collectionFinal reportCessna 180 · Wasilla, AKThe pilot's failure to maintain directional control during landing, which resulted in a collision with terrain. Contributing to the accident was the loose dirt and gravel deposited in the center of the runway.NTSB WPR16LA109Accident · No injuriesLimited investigationFinal reportCessna 172RG · Las Vegas, NVThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion.NTSB GAA16CA243Accident · No injuriesData collectionFinal reportPiper PA-28 · Crystal River, FLThe student pilot's failure to maintain directional control during the takeoff, which resulted in runway excursion and collision with a ditch. Contributing to the accident was the improper flap retraction procedure employed by the pilot during takeoff.NTSB GAA16CA238Accident · No injuriesData collectionFinal reportWaco YKS 7 · Millersburg, OHThe pilot's loss of directional control during landing in gusting wind conditions resulting in excessive brake application, and airplane nose over.NTSB ERA16LA183Accident · No injuriesLimited investigationFinal reportPiper PA 22 · Gallatin, TNThe pilot's inadequate preflight inspection, which resulted in an inflight fire due to the presence of a bird nest in the engine compartment.NTSB CEN16LA185Accident · No injuriesLimited investigationFinal reportJewett Brandon RV 6 · McKinney, TXThe pilot’s loss of directional control during takeoff.NTSB CEN16LA183Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US Z-150 · Edmond, OKThe pilot’s failure to control the balloon’s descent rate during the landing approach, which resulted in a hard landing.NTSB CEN16LA182Accident · 1 fatalLimited investigationFinal reportBell 47G 3B 1 · Portia, ARThe pilot's decision to perform a sliding takeoff from the elevated platform, which resulted in a dynamic rollover when the right skid plate caught on a protruding screw. Contributing to the accident was the pilot's failure to adequately inspect the landing…NTSB WPR16LA107Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Acampo, CAA total loss of engine power due to a fatigue fracture of the fuel pressure line that connected the fuel control unit and the fuel flow transducer due to vibration as the result of a fatigue fracture of an associated support clamp. Contributing to the…NTSB GAA16CA237Accident · No injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe pilot's failure to monitor the parked vehicle, which resulted in a ground collision and substantial damage to the left wing.NTSB GAA16CA236Accident · No injuriesData collectionFinal reportPiper PA 28R · Lee's Summit, MOThe pilot's improper pitch control after the landing flare, resulting in an aerodynamic stall, hard landing, and consequent substantial left wing damage.NTSB GAA16CA232Accident · No injuriesData collectionFinal reportPiper PA 12 · Simsbury, CTThe pilot's failure to attain the proper touchdown point and the airplane's subsequent impact with a fence during an attempted aborted landing.NTSB CEN16LA180Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Lyons Point, LAA total loss of engine power due to debris contamination of the fuel system. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB WPR16LA105Accident · Minor injuriesLimited investigationFinal reportBeech B24R · Groveland, CAThe pilot's decision to conduct an upslope, downwind takeoff combined with an improper flap setting, which resulted in the airplane's inability to clear trees beyond the runway end. The reason for the improper flap setting could not be determined.NTSB GAA16CA227Accident · Minor injuriesData collectionFinal reportAmerican Champion 8GCBC · Plainview, TXThe pilot's failure to maintain directional control during gusty wind conditions. Contributing to the outcome was the pilot's exceedance of the maximum crosswind component during takeoff.NTSB WPR16FA103Accident · Serious injuriesField investigationFinal reportPiper PA28 · Pomona, CAThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA16CA224Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Oberlin, KSThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, and a ground loop.NTSB WPR16FA102Accident · 1 fatalField investigationFinal reportBeech G35 · Surprise, AZThe mechanic's failure to properly secure the bolt connecting the throttle cable to the carburetor during the installation of the carburetor, which resulted in a loss of engine power.NTSB GAA16CA229Accident · No injuriesData collectionFinal reportWaco Classic YMF · Pace, FLThe pilot's failure to maintain directional control during the takeoff roll, and his excessive pitch attitude at low airspeed during initial climb, resulting in an aerodynamic stall and consequent ground impact.NTSB GAA16CA228Accident · No injuriesData collectionFinal reportBeech C23 · Yucca Valley, CAThe pilot's failure to attain airspeed and a positive rate of climb during takeoff in gusty wind conditions, resulting in a loss of directional control, an uncontrolled descent and collision with terrain.NTSB GAA16CA226Accident · No injuriesData collectionFinal reportCessna TR182 · Bloomington, INThe pilot's failure to maintain the airplane's descent rate resulting in a hard landing, and subsequent substantial damage to the firewall.NTSB ERA16LA179Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12 D · Critz, VAThe pilot’s failure to maintain airspeed while on final approach, which resulted in an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.NTSB ANC16FA023Accident · 1 fatalField investigationFinal reportAirbus AS350 · Skagway, AKThe pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in the pilot experiencing a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident were the…NTSB WPR16LA101Accident · No injuriesLimited investigationFinal reportAntonov AN2 · San Bernardino, CAThe mechanic’s failure to inspect the fine fuel filter gascolator as required during the most recent inspection, which resulted in a total loss of engine power due to fuel contamination.NTSB GAA16CA223Accident · No injuriesData collectionFinal reportCessna T206 · Jasper, TXThe pilot's failure to maintain pitch control during the landing flare, which resulted in abnormal runway contact, a nose wheel landing gear collapse, and runway excursion.NTSB GAA16CA221Accident · No injuriesData collectionFinal reportStinson 108 · Batavia, OHThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion. Contributing to the accident was the pilot's incorrect brake application during the runway excursion, which resulted in a nose over.NTSB GAA16CA220Accident · No injuriesData collectionFinal reportCessna 172 · Richmond, KYThe student pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and collision with tree(s).NTSB GAA16CA222Accident · No injuriesData collectionFinal reportPiper PA32RT · Gainesville, GAThe pilot's failure to maintain an appropriate descent rate during the landing flare in gusty crosswind conditions, which resulted in a hard landing, left main landing gear collapse, and runway excursion.NTSB CEN16LA175Accident · 1 fatalLimited investigationFinal reportAirborne Windsports PTY Edge X Classic · Rush City, MNThe student pilot's failure to maintain the appropriate pitch attitude during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the student pilot’s decision to conduct a solo flight without a solo endorsement in an…NTSB CEN16FA172Accident · 1 fatalField investigationFinal reportCessna 310F · North Little Rock, ARThe pilot's failure to promptly feather the left propeller upon the initial loss of engine power shortly after takeoff and his failure to maintain airspeed while maneuvering with one engine inoperative, which resulted in a loss of control at a low altitude.…