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 WPR10CA455Accident · No injuriesData collectionFinal reportMaule MX7 · Willows, CAThe pilot's inadequate compensation for the gusty crosswind condition and his failure to maintain directional control.Sep 11, 2010 · N6138Y · Substantial damageNTSB CEN10CA544Accident · No injuriesData collectionFinal reportPiper PA22 · Atkinson, NEThe pilot's failure to maintain directional control while landing with a crosswind.Sep 11, 2010 · N6064D · Substantial damageNTSB ANC10CA092Accident · Minor injuriesData collectionFinal reportPiper J5A · Chickaloon, AKThe pilot's excessive use of brakes during a rejected takeoff, resulting in a nose over.Sep 11, 2010 · N35589 · Substantial damageNTSB 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.Sep 11, 2010 · N598AL · Substantial damageNTSB WPR10LA457Accident · No injuriesLimited investigationFinal reportMyers THORP-18 · Jerome, IDThe pilot's failure to maintain directional control during the landing roll in gusty crosswinds.Sep 10, 2010 · N330JH · Substantial damageNTSB 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.Sep 10, 2010 · N2312Y · Substantial damageNTSB CEN10IA535Incident · No injuriesIncident investigationFinal reportEmbraer 500 · Brenham, TXThe pilots’ decision to depart with a known failed brake control unit.Sep 10, 2010 · N226CP · Minor damageNTSB 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.Sep 9, 2010 · N2753M · Substantial damageNTSB 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.Sep 9, 2010 · N180LE · Substantial damageNTSB 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.Sep 9, 2010 · N112TH · Substantial damageNTSB 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.Sep 9, 2010 · N83395 · Substantial damageNTSB 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.Sep 8, 2010 · N804GK · Substantial damageNTSB CEN10LA526Accident · 1 fatalLimited investigationFinal reportThompson Kolb Twinstar Mark · Elkhart, INThe pilot's failure to maintain control of the airplane during the landing approach.Sep 8, 2010 · N408K · Substantial damageNTSB CEN10CA527Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1-34R · Hampshire, ILThe pilot’s failure to attain the proper touchdown point, resulting in a runway overrun.Sep 8, 2010 · N1130S · Substantial damageNTSB WPR10CA451Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Paradise Lakes Estates, CAThe pilot's failure to maintain clearance from a fence during taxi.Sep 7, 2010 · N32025 · Substantial damageNTSB 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.Sep 7, 2010 · N2081U · Substantial damageNTSB 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.Sep 6, 2010 · N4622C · Substantial damageNTSB 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.Sep 6, 2010 · N515CW · Substantial damageNTSB 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.Sep 6, 2010 · N374WZ · Substantial damageNTSB ERA10CA469Accident · Serious injuriesData collectionFinal reportCessna 140 · Levant, METhe pilot's failure to obtain adequate airspeed during takeoff, which resulted in an aerodynamic stall.Sep 6, 2010 · N3650V · Substantial damageNTSB 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.Sep 6, 2010 · N4632A · Substantial damageNTSB 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.Sep 6, 2010 · N731PQ · Substantial damageNTSB CEN10CA522Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Berrien Springs, MIThe flight instructor's delayed remedial action, which resulted in a hard landing.Sep 6, 2010 · N404SE · Substantial damageNTSB 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.Sep 6, 2010 · N9128D · Substantial damageNTSB 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.Sep 5, 2010 · N16LH · Substantial damageNTSB CEN10CA530Accident · No injuriesData collectionFinal reportCullis Ultracruiser Sport · Defiance, OHThe pilot's failure to maintain aircraft control during the landing roll.Sep 5, 2010 · N716CS · Substantial damageNTSB 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.Sep 5, 2010 · N819WW · Substantial damageNTSB 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…Sep 4, 2010 · N907WN · 2 aircraft · No damageNTSB 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.Sep 4, 2010 · N812KT · Substantial damageNTSB 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.Sep 4, 2010 · N23471 · Substantial damageNTSB 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.Sep 4, 2010 · N1370V · Substantial damageNTSB 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.Sep 4, 2010 · N9942M · Substantial damageNTSB WPR10LA472Accident · No injuriesLimited investigationFinal reportCessna T188C · Craigmont, IDThe pilot's failure to maintain directional control during the landing roll.Sep 3, 2010 · N9980J · Substantial damageNTSB 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.Sep 3, 2010 · N4427F · Substantial damageNTSB 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.Sep 3, 2010 · N2068Z · Substantial damageNTSB 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.Sep 3, 2010 · N7415B · Substantial damageNTSB 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.Sep 3, 2010 · N333HK · Substantial damageNTSB 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.Sep 3, 2010 · N77TX · Substantial damageNTSB WPR10LA445Accident · Serious injuriesLimited investigationFinal reportMorehead KR-2 · Rancho Murieta, CAThe pilot’s improper flare and recovery from a bounced landing.Sep 2, 2010 · N522PC · Substantial damageNTSB 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…Sep 2, 2010 · N832B · Substantial damageNTSB 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.Sep 2, 2010 · N320CY · Substantial damageNTSB 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.Sep 2, 2010 · N10128 · Substantial damageNTSB CEN10CA516Accident · No injuriesData collectionFinal reportChampion 7KCAB · North Fork, NEThe student pilot's loss of directional control during landing, which resulted in a ground loop.Sep 2, 2010 · N1678G · Substantial damageNTSB ANC10CA082Accident · No injuriesData collectionFinal reportPiper PA-20 · Akhiok, AKThe pilot's failure to maintain directional control while maneuvering at a low altitude.Sep 2, 2010 · N1594A · Substantial damageNTSB 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.Sep 1, 2010 · N2156K · Substantial damageNTSB 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.Sep 1, 2010 · N2267U · Minor damageNTSB 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…Aug 31, 2010 · N67264 · Substantial damageNTSB 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.Aug 31, 2010 · N1534C · Substantial damageNTSB 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…Aug 31, 2010 · N6125X · Substantial damageNTSB 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.Aug 31, 2010 · N175SP · Substantial damage