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 ANC15CA013Accident · No injuriesData collectionFinal reportStinson 108 · Cordova, AKThe pilot's loss of directional control during landing, resulting in a collision with terrain.Mar 1, 2015 · N4449P · Substantial damageNTSB WPR15LA116Accident · Serious injuriesLimited investigationFinal reportBell 47G 2A · Ivanhoe, CAThe pilot’s failure to maintain clearance from a power line while maneuvering at low altitude.Feb 27, 2015 · N4774S · Substantial damageNTSB CEN15CA160Accident · Serious injuriesData collectionFinal reportZenith Acft Stol CH 701 · Marion, SDThe pilot failed to maintain control of the airplane while maneuvering to land resulting in contact with a power line and the ground. Contributing to the accident was the pilot's lack of familiarity with the airplane.Feb 27, 2015 · N511QC · Substantial damageNTSB CEN15CA159Accident · No injuriesData collectionFinal reportArnold Zodiac CH 650 · Greeley, COThe pilot was unable to maintain directional control during the landing due to the foreign object that lodged behind the rudder.Feb 27, 2015 · N715AK · Substantial damageNTSB CEN15FA154Accident · 1 fatalField investigationFinal reportRose Thunder Mustang · Helotes, TXThe pilot’s failure to maintain terrain clearance from terrain after initiating an aerobatic maneuver at a low altitude.Feb 25, 2015 · N7TR · DestroyedNTSB WPR15CA115Accident · No injuriesData collectionFinal reportPiper PA 28R-201 · Phoenix, AZThe pilot under instruction's inadvertent retraction of the landing gear during the landing rollout.Feb 24, 2015 · N963WW · Substantial damageNTSB ERA15LA135Accident · No injuriesLimited investigationFinal reportCessna 208 · Baltimore, MDThe ground service vehicle operator's failure to yield right of way to the airplane due to distraction, which necessitated the pilot's use of reverse thrust and braking to avoid a collision and resulted in the airplane's empennage striking the ground.Feb 24, 2015 · N989FX · Substantial damageNTSB WPR15LA111Accident · 1 fatalLimited investigationFinal reportPiper PA46 - 350P · Spokane, WAA total loss of engine power due to the refueler’s incorrect refueling of the airplane. Contributing to the accident was the fixed-base operator’s improper fueling nozzle, which facilitated the use of an incorrect fuel, and the pilot’s inadequate preflight…Feb 22, 2015 · CGVZW · DestroyedNTSB WPR15CA114Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Camarillo, CAThe pilot's failure to maintain directional control during the landing roll.Feb 22, 2015 · N4155U · Substantial damageNTSB CEN15CA151Accident · No injuriesData collectionFinal reportCessna 172P · Kankakee, ILThe student pilot's improper flight control inputs resulting in the loss of control during the landing flare.Feb 21, 2015 · N54974 · Substantial damageNTSB CEN15LA156Accident · No injuriesLimited investigationFinal reportAgusta Aerospace AW119 Mkii · Gulf of MexicoThe fracture of the tail rotor pitch change link due to excessive bearing rotational friction, which resulted from the bearings being installed in exceedance of the maximum allowable torque during the last overhaul of the pitch change link.Feb 20, 2015 · N802SM · Substantial damageNTSB CEN15LA149Accident · No injuriesLimited investigationFinal reportPiper PA 32RT-300T · Lubbock, TXThe pilot's delayed decision to abort the takeoff after the airplane did not lift off as expected due to an inaccurate airspeed indication and tailwind condition, which resulted in a subsequent runway overrun.Feb 20, 2015 · N22267 · Substantial damageNTSB ERA15LA134Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Lexington, KYMaintenance personnel's failure to properly inspect and clean the engine ignition harness spark plug terminals, which resulted in a partial loss of engine power during an attempted takeoff.Feb 19, 2015 · N358CD · Substantial damageNTSB ERA15LA133Accident · 1 fatalLimited investigationFinal reportJohnson Joel H Rans S-6ES Coyote II · Rincon, PRThe inadequate maintenance and inspection of the fuel system, which resulted in partial blockage of a fuel filter, a partial loss of engine power, and subsequent ditching.Feb 19, 2015 · N5196W · Substantial damageNTSB OPS15IA011Incident · No injuriesIncident investigationFinal reportEmbraer EMB 145LR · Chicago, ILThe flight crew's failure to manage cockpit tasks during taxi resulting in a loss of situation awareness and subsequently taxiing past a required turn point and onto an active runway without clearance. Contributing to the runway incursion was the ground…Feb 18, 2015 · N698CB · 2 aircraft · No damageNTSB WPR15CA112Accident · No injuriesData collectionFinal reportCessna T210 - L · The Dalles, ORThe pilot's failure to extend the landing gear prior to touch down. Contributing to the accident was the pilot's failure to utilize the pre-landing checklist.Feb 16, 2015 · N93810 · Substantial damageNTSB CEN15LA144Accident · No injuriesLimited investigationFinal reportBeech 58 · Denver, COThe pilot’s failure to maintain airplane control during a rejected takeoff from a slush-covered runway at night.Feb 16, 2015 · N297AT · Substantial damageNTSB WPR15LA104Accident · No injuriesLimited investigationFinal reportScottish Bulldog - 120 121 · Hayward, CAA total loss of engine power during the initial climb due to fuel contamination. Contributing to the accident was the pilot’s inadequate preflight inspection of the fuel system.Feb 15, 2015 · N706BD · Substantial damageNTSB WPR15CA107Accident · No injuriesData collectionFinal reportPiper PA28 - 180 · Garfield, WAThe pilot did not maintain clearance from a power line while maneuvering at a low altitude.Feb 15, 2015 · N7928W · Substantial damageNTSB GAA15CA039Accident · Serious injuriesData collectionFinal reportCameron Z90 - NO Series · Bernalillo, NMThe pilot's failure to maintain the descent rate, resulting in abnormal runway/ground contact.Feb 15, 2015 · N681SJ · No damageNTSB ERA15LA138Accident · No injuriesLimited investigationFinal reportBell 206 · Sevierville, TNAn uncontained engine failure, which resulted from insufficient lubrication of the No. 4 bearing due to carbon buildup on the filter screen of the bearing's oil supply nozzle.Feb 15, 2015 · N3176L · Substantial damageNTSB CEN15CA153Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Asherton, TXThe pilot did not maintain adequate clearance from the trees.Feb 15, 2015 · N7181S · Substantial damageNTSB WPR15LA103Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Layton, UTThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight and in-flight fuel planning, which did not account for the increased headwind.Feb 14, 2015 · N827CH · Substantial damageNTSB ERA15LA130Accident · Serious injuriesLimited investigationFinal reportRobertson James F Velocity STD/RG E · Sebastian, FLThe pilot’s loss of airplane control after takeoff, which resulted in collision with terrain. Contributing to the accident was the pilot’s failure to properly secure the cabin door and trim the airplane for takeoff, which resulted in the cabin door opening…Feb 13, 2015 · N112TH · Substantial damageNTSB CEN15CA188Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Akron, OHThe pilot's failure to maintain directional control during a crosswind landing in gusting crosswind conditions.Feb 12, 2015 · N427AB · Substantial damageNTSB WPR15CA102Accident · No injuriesData collectionFinal reportCessna 185 - E · Carson City, NVThe pilot's failure to maintain directional control during landing with a crosswind which resulted in a ground loop.Feb 11, 2015 · N185NV · Substantial damageNTSB ERA15FA129Accident · 4 fatalField investigationFinal reportBeech 1900 · Miami, FLThe left engine propeller's uncommanded travel to the feathered position during takeoff for reasons that could not be determined due to impact damage. Contributing to the accident was the flight crew's failure to establish a coordinated climb once the left…Feb 11, 2015 · YV1674 · DestroyedNTSB ERA15FA128Accident · 1 fatalField investigationFinal reportPiper PA28 · Greensboro, NCA total loss of engine power after takeoff due to fuel starvation as a result of excessive wear of the fuel selector valve. Also causal was the owner/operator and maintenance personnel's inadequate maintenance, and inadequate postmaintenance inspection.Feb 11, 2015 · N5985U · Substantial damageNTSB CEN15FA141Accident · 2 fatalField investigationFinal reportRichard Lacourse Wheeler Express · Kersey, COThe pilot's failure to maintain airplane control during an off-airport forced landing following a total loss of engine power for reasons that could not be determined during postaccident examination of the engine. Contributing to the accident was the pilots'…Feb 11, 2015 · N564ER · DestroyedNTSB WPR15LA101Accident · Minor injuriesLimited investigationFinal reportVans RV7 - Undesignat · Belfair, WAA total loss of engine power during cruise flight due to the fatigue failure of the engine crankshaft. Contributing to the accident was the unapproved repair and improper inspection of the engine crankshaft.Feb 10, 2015 · N513BW · Substantial damageNTSB ERA15LA125Accident · No injuriesLimited investigationFinal reportCessna 402C · Isla de Vieques, PRThe pilot's failure to maintain directional control during the landing roll with a strong crosswind, which resulted in a runway excursion.Feb 10, 2015 · N223PB · Substantial damageNTSB CEN15LA140Accident · Minor injuriesClass 3 · LimitedFinal reportEmbraer ERJ 190 100 IGW · Houston, TXAn undetermined malfunction of the nosewheel steering control module, which resulted in the nose landing gear being jammed in the gear bay. Contributing to the accident was the improper rigging of the nosewheel steering feedback sensors during installation.Feb 10, 2015 · N953UW · Substantial damageNTSB WPR15CA100Accident · Minor injuriesData collectionFinal reportCessna U206 - G · Kernville, CAThe pilot's inadequate flare and failure to maintain airplane control during the landing with a tailwind which resulted in a bounce, long landing, and subsequent runway excursion.Feb 9, 2015 · CFGQQ · Substantial damageNTSB ERA15LA124Accident · No injuriesLimited investigationFinal reportDehavilland DHC 6 Twin Otter · Sebastian, FLThe pilot's failure to conduct all of the required items on the Before Starting Engines checklist, which resulted in her failure to detect an open hydraulic circuit breaker and led to insufficient hydraulic pressure to operate the airplane's brakes, her…Feb 9, 2015 · N30EA · 2 aircraft · Substantial damageNTSB ERA15LA123Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Fort Meade, MDThe mechanic’s failure to detect the incorrect dry valve tappet clearances while troubleshooting ongoing engine issues, which resulted in partial loss of engine power during takeoff. Contributing to the partial loss of engine power was the mechanic's failure…Feb 8, 2015 · N6116L · Substantial damageNTSB ERA15CA126Accident · No injuriesData collectionFinal reportCessna 152 · Shirley, NYThe student pilot's initiation of the flare while too high above the runway, resulting in an aerodynamic stall, hard landing, and loss of directional control.Feb 7, 2015 · N5416B · Substantial damageNTSB CEN15LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Slaton, TXMaintenance personnel’s improper installation of the engine data monitor (EDM), which was not in accordance with the supplemental type certificate instructions and resulted in engine warning indications and the pilot’s subsequent reaction to the warning…Feb 5, 2015 · N602PB · Substantial damageNTSB CEN15LA137Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Andrews, TXThe pilot's failure to note that icing conditions existed in the airport area despite having received that information in a preflight briefing, which resulted in his flight into an area of icing and the subsequent loss of airplane control due to ice…Feb 5, 2015 · N29AC · Substantial damageNTSB CEN15FA136Accident · 1 fatalField investigationFinal reportCessna 441 · Argyle, TXThe pilot's failure to maintain adequate airspeed during the instrument approach in night instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin at a low altitude.Feb 5, 2015 · N441TG · Substantial damageNTSB CEN15FA135Accident · 1 fatalField investigationFinal reportPiper PA46 500TP · Lubbock, TXThe pilot's loss of airplane control due to spatial disorientation and light ice accumulation while operating in night, instrument meteorological conditions with gusting wind.Feb 5, 2015 · N301D · DestroyedNTSB ERA15CA121Accident · No injuriesData collectionFinal reportAutogyro Calidus · Crozet, VAThe pilot's improper control inputs which resulted in a loss of control and rollover during the takeoff roll.Feb 4, 2015 · N595X · Substantial damageNTSB ERA15CA120Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Brookneal, VAThe flight instructor and pilot-rated student's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.Feb 4, 2015 · N619GB · Substantial damageNTSB ERA15CA117Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Valdosta, GAThe pilot's failure to compensate for gusty wind conditions during the landing flare, which resulted in a hard landing and subsequent nose landing gear collapse.Feb 2, 2015 · N42993 · Substantial damageNTSB ERA15CA127Accident · No injuriesData collectionFinal reportSchweizer 269C 1 · Carthage, NYThe non-helicopter-rated pilot's improper decision to operate the helicopter at low-level and his inability to adequately see the horizon over snow and ice, which resulted in controlled flight into terrain.Feb 1, 2015 · N20059 · Substantial damageNTSB ANC15LA010Accident · No injuriesLimited investigationFinal reportPiper PA 12 · Palmer, AKThe student pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s inadvertent switching of the fuel selector to the “off” position during the attempted engine restart.Feb 1, 2015 · N2370M · Substantial damageNTSB ERA15CA122Accident · Minor injuriesData collectionFinal reportEvolution Revo · Bushnell, FLThe pilot's failure to maintain airspeed during approach in variable wind, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.Jan 31, 2015 · N40EV · Substantial damageNTSB ANC15FA009Accident · Serious injuriesField investigationFinal reportPiper PA 18 · Wasilla, AKBoth pilots’ inadequate visual lookout and failure to see and avoid each other while in level cruise flight, which resulted in a midair collision. Contributing to the accident was the obscuration of the other pilot’s visibility due to sun glare.Jan 31, 2015 · N82735 · 2 aircraft · Substantial damageNTSB WPR15CA097Accident · No injuriesData collectionFinal reportSchneider Richard J Alaskan Bushmaster · Newburg, ORThe pilot's failure to maintain directional control during the takeoff roll into sunlight, which restricted his visibility.Jan 29, 2015 · N36NC · Substantial damageNTSB WPR15CA095Accident · No injuriesData collectionFinal reportPiper PA 12 · Ridgefield, WAThe pilot's delayed action to use carburetor heat before the engine experienced a total loss of power while operating at cruise flight in conditions conducive to carburetor icing.Jan 29, 2015 · N918TF · Substantial damageNTSB CEN15LA131Accident · No injuriesLimited investigationFinal reportBell-Watson 47 G · North Little Rock, ARThe flight instructor’s failure to maintain adequate rotor rpm during the practice touchdown autorotation, which resulted in a subsequent loss of helicopter control and impact with terrain.Jan 29, 2015 · N43762 · Substantial damage