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 CEN16LA250Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Oak Ridge, LAThe pilot's failure to maintain airplane control during the aborted takeoff, which resulted in it becoming airborne momentarily and then over running the runway.NTSB CEN16FA241Accident · 1 fatalField investigationFinal reportBoeve Earl Seawind · Buena Vista, COThe pilot's failure to maintain control of the airplane during a forced landing following a partial loss of engine power, which resulted in a hard landing and nose over. The reason for the loss of engine power could not be determined due to the severity of…NTSB ANC16LA038Accident · No injuriesLimited investigationFinal reportCessna 206 · Halibut Cove, AKThe pilot's failure to maintain clearance from trees during an attempted go-around.NTSB ANC16CA040Accident · No injuriesData collectionFinal reportCessna 180 · Nome, AKThe pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the runway and impacting a barricade. Contributing to the accident was the airport manager's improper placement and marking of a metal…NTSB ERA16FA238Accident · 1 fatalField investigationFinal reportGerdts Mark E RV7A · Weston, FLThe pilot's loss of airplane control for reasons that could not be determined based on the available evidence.NTSB ERA16CA241Accident · No injuriesData collectionFinal reportCessna 305 · Shirley, NYThe pilot's failure to maintain directional control while landing. Contributing to the accident was the pilot's decision to accept an advised runway rather than determine actual airport winds, which resulted in the airplane landing with a quartering tailwind.NTSB CEN16LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA 25-235 · Arlington, WIThe pilot’s failure to establish proper airspeed and angle-of-attack during takeoff with the airplane at its maximum gross weight in elevated density altitude and gusting tailwind conditions, which resulted in an aerodynamic stall.NTSB CEN16FA240Accident · 2 fatalField investigationFinal reportAeronca 11AC · Frankenmuth, MIThe pilot's loss of control for undetermined reasons based on available information.NTSB WPR16LA134Accident · No injuriesLimited investigationFinal reportBell OH 58A · Brawley, CAThe engine's degraded performance due to excessive wear of the engine bleed valve, which prevented it from closing during the accident flight. Contributing to the accident was the operator's failure to overhaul the bleed valve within the…NTSB WPR16LA133Accident · No injuriesLimited investigationFinal reportCessna 172 · Salmon, IDA loss of engine power due to water in the fuel system. Contributing to the accident was an inadequate preflight inspection that failed to eliminate water from the fuel system.NTSB GAA16CA360Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during the landing flare, which resulted in a runway excursion, and impact with a sign.NTSB GAA16CA357Accident · Minor injuriesData collectionFinal reportBeech 23 · Maryville, MOThe pilot's failure to see and avoid power lines on approach during landing, resulting a power line strike, uncontrolled descent, and collision with terrain. Contributing to the accident was the pilot's inadequate pre-flight planning.NTSB GAA16CA353Accident · Minor injuriesData collectionFinal reportCessna 182 · Hungry Horse, MTThe pilot's decision to land on unsuitable wet terrain, and his failure to stop prior to the end of the runway, which resulted in a runway overrun and impact with tree(s).NTSB ERA16CA239Accident · Serious injuriesData collectionFinal reportPiper PA 22-160 · Harrisonburg, VAThe pilot's loss of directional control during takeoff in gusting crosswind conditions.NTSB CEN16LA242Accident · Minor injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Wyoming, MNThe pilot’s inadequate flight planning and navigation for a flight at night, which resulted in his having to conduct a precautionary landing on an interstate highway due to low fuel and impacting the post of a wire road divider.NTSB WPR16LA136Accident · Serious injuriesLimited investigationFinal reportRans S6 · Bridgeport, CAThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering and his improper decision to maneuver low over a home, which resulted in an aerodynamic stall at too low of an altitude to recover.NTSB GAA16CA364Accident · No injuriesData collectionFinal reportCessna 172RG · Manhattan, KSThe flight instructor and pilot receiving instruction's omission to use an appropriate checklist and extend the landing gear prior to landing, which resulted in substantial damage to the aircraft's fuselage and bulkhead.NTSB GAA16CA363Accident · No injuriesData collectionFinal reportHughes 269C · Cullman, ALThe helicopter flight instructor candidate's improper execution of the autorotation, resulting in abnormal ground contact and subsequent damage to the vertical stabilizer and tail rotor drive assembly.NTSB GAA16CA358Accident · No injuriesData collectionFinal reportCessna 172 · Bountiful, UTThe pilot's decision to fly into a canyon without sufficient room to reverse course if necessary, which resulted in an emergency landing, loss of directional control, collision with terrain, and a post-crash fire.NTSB GAA16CA354Accident · No injuriesData collectionFinal reportCessna 188 · Saratoga, WYThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in substantial damage.NTSB ERA16CA303Accident · No injuriesData collectionFinal reportCessna 152G · Augusta, METhe pilot's failure to compensate for the gusting wind conditions during a short-field landing and the designated pilot examiner's delayed remedial action, which resulted in the wing tip contacting the runway during the go-around.NTSB GAA16CA365Accident · No injuriesData collectionFinal reportCessna 172RG · Stamford, TXThe pilot's failure to maintain clearance from a hangar during taxi for departure.NTSB GAA16CA362Accident · No injuriesData collectionFinal reportCessna U206 · Ely, NVThe flight instructor's incorrect pitch control during the landing flare, which resulted in a tail strike.NTSB GAA16CA359Accident · No injuriesData collectionFinal reportPiper PA28 · Amarillo, TXThe pilot's failure to attain an adequate rate of climb, which resulted in off airport landing and substantial damage to the fuselage and right wing.NTSB GAA16CA345Accident · No injuriesData collectionFinal reportCessna 170 · Everett, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and substantial damage to the fuselage.NTSB GAA16CA343Accident · No injuriesData collectionFinal reportCessna 172 · Frederick, MDThe student pilot's failure to maintain pitch control during the touch down resulting in a bounced landing, subsequent hard landing and substantial damage to the firewall.NTSB ERA16LA236Accident · No injuriesLimited investigationFinal reportPiper PA34 · Winnsboro, SCThe pilot's failure to maintain sufficient airspeed during a go-around, and the flight instructor's delayed remedial action, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the…NTSB ERA16CA277Accident · Minor injuriesData collectionFinal reportCessna 172 · Gray, GAThe pilot's failure to properly manage the available fuel supply, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA16CA237Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Honesdale, PAThe pilot's inadequate preflight planning, which resulted in his attempt to take off near the airplane’s maximum gross weight in high-density altitude conditions that degraded the airplane’s takeoff and climb performance and resulted in an aborted takeoff and…NTSB CEN16LA245Accident · Serious injuriesLimited investigationFinal reportEvolution Revo · Holland, MIThe flight instructor's failure to maintain aircraft control during landing as a result of his failure to adjust the electric trim to the proper position for landing.NTSB ANC16CA036Accident · No injuriesData collectionFinal reportCessna A185F · King Salmon, AKThe pilot's failure to maintain airplane control while landing in gusty wind conditions, resulting in a noseover.NTSB ERA16CA233Accident · Minor injuriesData collectionFinal reportCessna T206 · Farmington, PAThe pilot's failure to obtain the proper touchdown point and failure to perform a go-around once a safe landing on the runway could not be accomplished.NTSB CEN16LA236Accident · 1 fatalLimited investigationFinal reportCessna 150L · Detroit, MIThe pilot’s disregard of the banner-tow operator's policy regarding the maximum allowable flight duration, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC16CA041Accident · No injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe pilot's selection of unsuitable terrain for an off-airport landing, which resulted in a collision with trees and a ground-loop.NTSB WPR16LA171Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Schafer Meadows, MTA loss of directional control while landing, which resulted in a runway excursion and landing gear collapse for reasons that could not be determined.NTSB GAA16CA375Accident · No injuriesData collectionFinal reportCessna A185 · Hayden Lake, IDThe pilot's failure to retract the amphibious airplane's land-wheels prior to landing on a lake, which resulted in a nose over.NTSB GAA16CA349Accident · No injuriesData collectionFinal reportCessna 150 · Reno, NVThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, impact with a sign, and left wing damage.NTSB GAA16CA335Accident · Minor injuriesData collectionFinal reportRans Employee Flying Club Rans S 6S · Richwood, OHThe pilot's exceedance of the critical angle of attack during an initial climb of an aborted landing, which resulted in an inadvertent aerodynamic stall and impact with terrain.NTSB DCA16CA193Accident · Serious injuriesData collectionFinal reportBoeing 737 · New Orleans, LAthe improper placement of the coffee pot on the beverage cart and failure to use a safe-pour lid.NTSB CEN16LA247Accident · Serious injuriesLimited investigationFinal reportBeech E 90 · Longmont, COThe pilot's unintentional activation of the green jump light before the airplane was properly configured and slowed for a jump and the jumpers' improper decision to continue with the jump after they recognized that the airplane was at a higher-than-normal…NTSB WPR16FA131Accident · 1 fatalField investigationFinal reportCessna A185F · Coeur d'Alene, IDThe pilot's failure to maintain clearance from trees while maneuvering at low altitude in mountainous terrain.NTSB WPR16CA147Accident · No injuriesData collectionFinal reportStinson L 5G · Beckwourth, CAThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the check pilot's failure to act in a timely manner to prevent the airplane from departing the runway.NTSB GAA16CA344Accident · No injuriesData collectionFinal reportBenjamin Harold E RV-4 · Fitchburg, MAThe pilot's failure to maintain directional control upon landing, which resulted in a runway excursion followed by impact with terrain.NTSB GAA16CA338Accident · No injuriesData collectionFinal reportNorth American SNJ · Jackson, MIThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, right main landing gear collapse, and impact with the ground.NTSB GAA16CA336Accident · No injuriesData collectionFinal reportCessna 152 · Delta, COThe pilot exceeded the critical angle of attack during the initial climb in tailwind conditions, which resulted in an aerodynamic stall.NTSB GAA16CA334Accident · No injuriesData collectionFinal reportHubbard William H Lightning · Kokomo, INThe pilot's failure to maintain directional control during the landing flare at night, which resulted in an impact with a runway light and runway sign.NTSB GAA16CA333Accident · Minor injuriesData collectionFinal reportCessna 172 · Anthony, NMThe pilot's failure to maintain clearance from a cable while maneuvering at a low altitude over water, which resulted in a collision with a cable and impact with water.NTSB GAA16CA350Accident · No injuriesData collectionFinal reportPiper PA 24 · Springfield, MOThe pilot's failure to ensure that the landing gear was in the down and locked position prior to touchdown.NTSB GAA16CA332Accident · No injuriesData collectionFinal reportThrush S2R · Lazbuddie, TXThe pilot's failure to avoid the metering loop pole during an aerial application.NTSB ERA16LA228Accident · Serious injuriesLimited investigationFinal reportAmerican AA1 · Knoxville, TNThe pilot's failure to maintain directional control during the landing roll in a quartering headwind.