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 WPR10CA455Accident · No injuriesData collectionFinal reportMaule MX7 · Willows, CAThe pilot's inadequate compensation for the gusty crosswind condition and his failure to maintain directional control.NTSB CEN10CA544Accident · No injuriesData collectionFinal reportPiper PA22 · Atkinson, NEThe pilot's failure to maintain directional control while landing with a crosswind.NTSB ANC10CA092Accident · Minor injuriesData collectionFinal reportPiper J5A · Chickaloon, AKThe pilot's excessive use of brakes during a rejected takeoff, resulting in a nose over.NTSB ANC10CA086Accident · No injuriesData collectionFinal reportRoberts Alan W Kitfox II · Fairbanks, AKThe pilot's failure to maintain proper aircraft control during landing and the subsequent go-around, resulting in a hard landing, and a collision with a signpost.NTSB WPR10LA457Accident · No injuriesLimited investigationFinal reportMyers THORP-18 · Jerome, IDThe pilot's failure to maintain directional control during the landing roll in gusty crosswinds.NTSB ERA10LA474Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Doerun, GAA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to select an adequate forced landing site and his excess speed during the landing.NTSB CEN10IA535Incident · No injuriesIncident investigationFinal reportEmbraer 500 · Brenham, TXThe pilots’ decision to depart with a known failed brake control unit.NTSB ERA10CA473Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Montauk, NYThe pilot's inadequate compensation for crosswind conditions which resulted in a hard landing and loss of directional control.NTSB ERA10CA472Accident · Minor injuriesData collectionFinal reportCessna 180 · Huron, NYThe pilot's inadequate preflight planning and preparation, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN10CA532Accident · Minor injuriesData collectionFinal reportRobertson Velocity · Wooster, OHA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB ANC10CA096Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chicken, AKThe pilot's decision to fly at a low altitude in terrain and weather conditions conducive to turbulence and downdrafts.NTSB ERA10FA471Accident · 1 fatalField investigationFinal reportCessna 182T · Helena, GAThe pilot’s continuance of the GPS approach below the minimum descent altitude while landing in instrument meteorological conditions.NTSB CEN10LA526Accident · 1 fatalLimited investigationFinal reportThompson Kolb Twinstar Mark · Elkhart, INThe pilot's failure to maintain control of the airplane during the landing approach.NTSB CEN10CA527Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1-34R · Hampshire, ILThe pilot’s failure to attain the proper touchdown point, resulting in a runway overrun.NTSB WPR10CA451Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Paradise Lakes Estates, CAThe pilot's failure to maintain clearance from a fence during taxi.NTSB CEN10FA520Accident · 2 fatalField investigationFinal reportCessna T210 · Mountain Home, ARThe pilot’s decision to continue flight into a known area of heavy rain and his subsequent failure to maintain aircraft control.NTSB WPR10CA480Accident · No injuriesData collectionFinal reportCessna A185 · Santa Ynez, CAThe pilot's failure to maintain directional control, likely due to the inadvertent control interference by a passenger. A finding in the accident was the pilot's improper pre flight briefing.NTSB WPR10CA425Accident · No injuriesData collectionFinal reportChris W Kleen RV-6 · Coeur D'Alene, IDThe pilot’s inadequate compensation for the crosswind that resulted in a loss of directional control.NTSB ERA10CA470Accident · Minor injuriesData collectionFinal reportNorth Wing Uum Sport X2 · Winterville, NCThe pilot's loss of directional control while landing during an encounter with a wind gust.NTSB ERA10CA469Accident · Serious injuriesData collectionFinal reportCessna 140 · Levant, METhe pilot's failure to obtain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB CEN10FA521Accident · No injuriesField investigationFinal reportCessna P210N · Caledonia, MIA loss of engine power as a result of a fatigue failure of the crankshaft due to the loss of engine case through-bolt torque. Contributing to the accident was a mechanic's use of incorrect hardware.NTSB CEN10CA536Accident · No injuriesData collectionFinal reportCessna A188B · Hondo, TXThe pilot’s delayed action to arrest the airplane’s descent, which resulted in a collision with terrain.NTSB CEN10CA522Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Berrien Springs, MIThe flight instructor's delayed remedial action, which resulted in a hard landing.NTSB ANC10CA088Accident · No injuriesData collectionFinal reportPiper PA-18-160 · Arctic Village, AKThe pilot's failure to maintain control of the airplane during an off-airport landing.NTSB CEN10CA540Accident · No injuriesData collectionFinal reportBeech E-90 · Colorado Springs, COThe pilot’s failure to ensure that the airplane’s parking brake was properly set before diverting his attention to other tasks.NTSB CEN10CA530Accident · No injuriesData collectionFinal reportCullis Ultracruiser Sport · Defiance, OHThe pilot's failure to maintain aircraft control during the landing roll.NTSB CEN10CA525Accident · Minor injuriesData collectionFinal reportWeber Acro Sport II · Plum City, WIThe pilot’s improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB OPS10IA538Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Los Angeles, CAFailure of the air traffic controller to exercise positive control of the situation by issuing clear and timely control instructions to the helicopter pilot. Contributing to the incident was delay by the helicopter pilot in responding to instructions issued…NTSB ERA10LA466Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Virginia Beach, VAA total loss of power due to water contamination in the fuel. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB ERA10FA464Accident · 2 fatalField investigationFinal reportCessna 150H · DeLand, FLThe pilot's failure to maintain adequate airspeed and airplane control during the initial climb, which resulted in an aerodynamic stall, wire strike, and subsequent impact with the ground.NTSB ERA10CA465Accident · No injuriesData collectionFinal reportStearman E75 · Jackson, GAThe pilot's diverted attention toward an unsecured engine cowl door after takeoff which resulted in his failure to maintain airspeed and altitude. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane.NTSB ANC10LA083Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Tuluksak, AKThe pilot's delayed application of full power during a soft/wet field takeoff, resulting in a collision with trees during takeoff.NTSB WPR10LA472Accident · No injuriesLimited investigationFinal reportCessna T188C · Craigmont, IDThe pilot's failure to maintain directional control during the landing roll.NTSB WPR10LA446Accident · Serious injuriesLimited investigationFinal reportBell 47G · Salinas, CAThe pilot's visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and loss of helicopter control.NTSB WPR10CA453Accident · No injuriesData collectionFinal reportCessna 150C · Fields, ORThe pilot's misjudged landing flare, resulting in a bounced landing and loss of directional control. Contributing to the accident was the pilot's inaccurate perception of the airplane’s proximity to the ground as a result of the featureless white landing area.NTSB WPR10CA447Accident · Serious injuriesData collectionFinal reportChampion 7EC · Aurora, ORThe pilot’s failure to maintain directional control during an attempted go around after landing, resulting in a runway excursion.NTSB CEN10FA519Accident · Serious injuriesField investigationFinal reportKwech Glasair RG Super 11S · Lake Elmo, MNThe pilot's failure to maintain control of the airplane during takeoff with gusty wind conditions, which resulted in a collision with terrain.NTSB CEN10CA565Accident · No injuriesData collectionFinal reportNorth American AT-6 · Blakesburg, IAThe pilot's excessive airspeed during the landing, which resulted in his decision to perform an intentional ground loop to avoid a runway overrun.NTSB WPR10LA445Accident · Serious injuriesLimited investigationFinal reportMorehead KR-2 · Rancho Murieta, CAThe pilot’s improper flare and recovery from a bounced landing.NTSB WPR10FA448Accident · 3 fatalField investigationFinal reportBeech 65 · Redwood City, CAA loss of power in the right engine for undetermined reasons and the pilot’s subsequent failure to maintain adequate airspeed, which resulted in a loss of control. Contributing to the loss of control was the regulatory certification basis of the airplane that…NTSB ERA10CA461Accident · No injuriesData collectionFinal reportYeager Lancair · McMinnville, TNThe pilot’s failure to properly latch the cockpit canopy prior to takeoff, resulting in his diverted attention and failure to maintain aircraft control.NTSB CEN10LA514Accident · 1 fatalLimited investigationFinal reportCessna 150L · Boone, IAThe pilot’s failure to maintain airplane control while performing low-level banner towing operations with a gusting wind.NTSB CEN10CA516Accident · No injuriesData collectionFinal reportChampion 7KCAB · North Fork, NEThe student pilot's loss of directional control during landing, which resulted in a ground loop.NTSB ANC10CA082Accident · No injuriesData collectionFinal reportPiper PA-20 · Akhiok, AKThe pilot's failure to maintain directional control while maneuvering at a low altitude.NTSB ERA10CA467Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Churchville, MDThe pilot’s failure to ensure that the fuel valve was in the "ON" position during his preflight inspection, resulting in the loss of engine power during takeoff.NTSB ERA10CA462Accident · Serious injuriesData collectionFinal reportHead Balloons AX9 118 · Hanover, NHThe balloon's encounter with an updraft, resulting in an immediate landing and an intentional collision with a tree.NTSB WPR10FA440Accident · 3 fatalField investigationFinal reportHiller UH 12E · Kamiah, IDIn-flight impact of a passenger's metal clipboard with the helicopter’s tail rotor, which resulted in destruction of the tail rotor and subsequent loss of control of the helicopter. The original location of the clipboard and how it became free could not be…NTSB WPR10CA442Accident · No injuriesData collectionFinal reportSchweizer 269C · Caldwell, IDThe failure of both pilots to maintain adequate main rotor RPM, the flight instructor's delayed remedial actions, and inadequate supervision of the flight.NTSB WPR10CA439Accident · Serious injuriesData collectionFinal reportAyres S2R-G10 · Ligurta, AZThe pilot's failure to maintain clearance from rising terrain. Contributing to the accident was the pilot's decision to orient the application tracks so that they did not provide the maximum possible clearance from the rising terrain, and, the predawn…NTSB ERA10LA457Accident · No injuriesLimited investigationFinal reportAero Commander 560E · Jacksonville, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of power in both engines during climb due to fuel contamination.