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 ANC15CA001Accident · No injuriesData collectionFinal reportCessna 180J · Gustavus, AKThe pilot's excessive use of brakes during the landing roll, which resulted in a nose over.Oct 9, 2014 · N180KN · Substantial damageNTSB WPR15CA007Accident · No injuriesData collectionFinal reportCessna T182T · Van Nuys, CAThe pilot's failure to monitor the distance between the left wing and blast fence while maneuvering behind another airplane.Oct 8, 2014 · N378MS · Substantial damageNTSB WPR15CA006Accident · No injuriesData collectionFinal reportMaule MX 7-235 · Big Creek, IDThe pilot's failure to maintain aircraft control while on final approach with shifting wind conditions.Oct 8, 2014 · N11ZA · Substantial damageNTSB WPR15GA005Accident · 1 fatalFinal reportMarsh S 2F3AT · El Portal, CAThe pilot's failure to maintain clearance from trees while maneuvering at a low altitude.Oct 7, 2014 · N449DF · DestroyedNTSB CEN15CA006Accident · Minor injuriesData collectionFinal reportPiper PA 31-350 · Glenham, SDThe pilot's improper fuel management, which resulted in losses of power on both engines due to fuel exhaustion.Oct 7, 2014 · N300VF · Substantial damageNTSB ERA15CA010Accident · No injuriesData collectionFinal reportToerner Bob SEA REY · Tampa, FLThe pilot's failure to retract the landing gear after takeoff, which resulted in the landing gear contacting the water while maneuvering at low altitude.Oct 6, 2014 · N345BT · Substantial damageNTSB WPR15CA004Accident · Minor injuriesData collectionFinal reportCessna 172S · Sedona, AZThe pilot's failure to maintain airplane control during the landing roll out.Oct 5, 2014 · N2179L · Substantial damageNTSB ERA15LA006Accident · Serious injuriesLimited investigationFinal reportSocata TBM 700 · Fayetteville, GAThe pilot’s inadvertent deactivation of the yaw damper in flight, which resulted in a prolonged side-slip condition that led to fuel starvation and the eventual total loss of engine power. Contributing to the accident was the pilot’s failure to attempt to…Oct 5, 2014 · N536EM · Substantial damageNTSB DCA15FA004Accident · No injuriesField investigationFinal reportEmbraer EMB 145LR · Jamaica, NYThe A340 captain's failure to maintain adequate clearance between his wing and the tail of the EMB-145.Oct 5, 2014 · N572RP · 2 aircraft · Substantial damageNTSB CEN15LA004Accident · 2 fatalLimited investigationFinal reportCelier Xenon R · Loma, COThe pilot’s failure to maintain clearance from a static wire and his decision to maneuver the gyroplane at low altitude.Oct 5, 2014 · N719MB · Substantial damageNTSB WPR15TA002Accident · No injuriesFinal reportRockwell International 690B · Grass Valley, CAThe pilot’s unstabilized approach and failure to go around and his subsequent failure to maintain directional control during the landing roll.Oct 4, 2014 · N700PQ · Substantial damageNTSB ERA15IA008Incident · No injuriesIncident investigationFinal reportCessna S550 · Tampa, FLThe lack of flat roller bearings in the two elevator trim tab actuators and maintenance personnel’s inadequate lubrication of the left elevator trim tab actuator, both of which resulted in the overstress fracture of the left internal screw and subsequent…Oct 4, 2014 · N550AJ · No damageNTSB ERA15CA007Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Maryville, TNThe pilot/owner's failure to maintain a stabilized approach during the final leg of the traffic pattern. Contributing to the accident was both pilot's lack of aeronautical decision making.Oct 4, 2014 · N85707 · Substantial damageNTSB CEN15LA021Accident · No injuriesLimited investigationFinal reportRaytheon 58 · Dixon, ILThe pilots’ improper decision to continue flight in icing conditions after the deicing boots could not shed accumulated ice, which resulted in a temporary loss of airplane control.Oct 4, 2014 · N345PG · Substantial damageNTSB CEN15FA003Accident · 3 fatalField investigationFinal reportBell Helicopter Textron 206L 1 · Wichita Falls, TXThe pilot’s failure to maintain yaw control when he applied power to execute a go-around at a low airspeed in dark, night conditions, which resulted in a rapid, uncommanded right yaw due to a loss of tail rotor effectiveness.Oct 4, 2014 · N335AE · DestroyedNTSB CEN15CA005Accident · No injuriesData collectionFinal reportCessna 152 · Arlington, TXThe pilot's inadequate flight preparation and navigation during a training flight resulting in collision with low wires.Oct 4, 2014 · N124RP · Substantial damageNTSB WPR15LA001Accident · 1 fatalLimited investigationFinal reportGaston Thomas D Thunder Mustang · Council, IDThe pilot's failure to maintain control while maneuvering for landing following a loss of oil pressure. Contributing to the accident was foreign material contamination of the oil system due to improper maintenance.Oct 3, 2014 · N51TG · DestroyedNTSB CEN15CA007Accident · Serious injuriesData collectionFinal reportBell 206B · Atlanta, ARThe pilot's inadequate preflight inspection when he did not remove a tie-down strap prior to takeoff, which resulted in a dynamic rollover.Oct 3, 2014 · N4426M · Substantial damageNTSB WPR15CA012Accident · No injuriesData collectionFinal reportCessna 180 · Marion, MTThe pilot's failure to maintain directional control during landing.Oct 2, 2014 · N156JM · Substantial damageNTSB ERA15IA009Incident · No injuriesIncident investigationFinal reportFunk Ralph Velocity Xlrg · Atlanta, GAThe pilot’s failure to maintain directional control during a hard landing, which resulted in the fracture of the nose landing gear.Oct 2, 2014 · N301EF · Minor damageNTSB ERA15CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Toccoa, GAThe private pilot's failure to maintain proper altitude and the flight instructor's failure to provide correction action, which resulted in a collision with terrain during landing.Oct 2, 2014 · N6044W · Substantial damageNTSB CEN15LA002Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woodsboro, TXThe pilot’s failure to recognize and correct for flight conditions conducive to a loss of tail rotor effectiveness, which resulted in a rapid, uncommanded right yaw and subsequent hard landing.Oct 2, 2014 · N49746 · Substantial damageNTSB ERA15LA001Accident · 1 fatalLimited investigationFinal reportAir Command 582 · Monongahela, PAThe amateur-built gyroplane’s collision with terrain for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s decision to conduct the flight without obtaining additional training.Oct 1, 2014 · UNREG · Substantial damageNTSB CEN15CA001Accident · No injuriesData collectionFinal reportPiper PA 25-235 · Yankton, SDThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Oct 1, 2014 · N6659Z · Substantial damageNTSB WPR14CA399Accident · No injuriesData collectionFinal reportCessna 172N · Thermal, CAThe student pilot's failure to maintain directional control during landing after an encounter with a dust devil.Sep 30, 2014 · N738TJ · Substantial damageNTSB ANC14CA090Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Port Alsworth, AKThe pilots failure to maintain control of the airplane during an aborted landing in gusty wind conditions.Sep 30, 2014 · N2976M · Substantial damageNTSB CEN14LA526Accident · Serious injuriesLimited investigationFinal reportPreiss Vans RV-9A · Hobart, OKA loss of engine power due to fuel exhaustion, which resulted from the pilot's erroneous preflight fuel calculations and inadequate in-flight fuel management.Sep 29, 2014 · N259H · Substantial damageNTSB CEN14FA522Accident · 1 fatalField investigationFinal reportCessna T337G · Plano, ILThe pilot’s failure to recognize the airplane’s low altitude and arrest the airplane’s descent on approach to the airport in dark night conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s degraded night…Sep 29, 2014 · N37E · Substantial damageNTSB ANC14CA089Accident · No injuriesData collectionFinal reportCessna 180 · Kodiak, AKThe pilots failure to maintain control of the airplane while taxiing in gusty wind conditions.Sep 29, 2014 · N2483C · Substantial damageNTSB WPR14CA397Accident · No injuriesData collectionFinal reportPiper PA 24-250 · Rancho Murieta, CAThe student pilot's failure to maintain adequate airspeed during takeoff and the certified flight instructors delayed remedial action, which resulted in the stall.Sep 28, 2014 · N8129P · Substantial damageNTSB ERA14LA465Accident · Minor injuriesLimited investigationFinal reportBritten-Norman BN-2A · Ceiba, PRThe pilot’s loss of consciousness during taxi for reasons that could not be determined based on the available information.Sep 28, 2014 · N906GD · Substantial damageNTSB ERA14LA462Accident · Serious injuriesLimited investigationFinal reportQuicksilver Eipper Acft GT 400 · Lebanon, CTThe pilot’s misjudgment of the takeoff distance needed to clear trees at the end of the runway.Sep 28, 2014 · N3740A · Substantial damageNTSB ERA14FA461Accident · 1 fatalField investigationFinal reportEagle R&D Helicycle · Gallatin, TNThe pilot's decision to fly the improperly balanced helicopter at high speed and low altitude, which resulted in a loss of control and collision with terrain. Contributing to the accident were the pilot's depression and resulting degradation of executive…Sep 28, 2014 · N7062U · Substantial damageNTSB CEN14CA528Accident · Minor injuriesData collectionFinal reportCessna 182G · Port Eads, LAThe pilot's improper decision to depart from a runway not suitable for takeoff, which resulted in a loss of aircraft control.Sep 28, 2014 · N2011R · Substantial damageNTSB ANC14LA091Accident · No injuriesLimited investigationFinal reportPiper J3 · Ft. Yukon, AKThe pilot's improper preflight inspection and in-flight fuel management, which resulted in fuel exhaustion and a subsequent forced landing.Sep 28, 2014 · N7092H · Substantial damageNTSB WPR14FA393Accident · 1 fatalField investigationFinal reportTifft Kitfox III · Lake Stevens, WAThe pilot's failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the inability of the flight instructor to take control…Sep 27, 2014 · N307KF · Substantial damageNTSB ERA14FA459Accident · 2 fatalField investigationFinal reportCessna 172M · Lancaster, NYThe other airplane pilot’s failure to maintain an adequate visual lookout for known traffic in the fly-in event traffic pattern, which resulted in a midair collision.Sep 27, 2014 · N9679H · 2 aircraft · DestroyedNTSB CEN14LA527Accident · 1 fatalLimited investigationFinal reportButcher Russell A RV9A · Shepherd, TXThe pilot’s loss of airplane control during the landing approach after a loss of engine power, which led to a collision with trees and terrain. Contributing to the accident was the pilot’s inadequate preflight fuel planning, which led to fuel exhaustion and…Sep 27, 2014 · N809RD · Substantial damageNTSB CEN14CA523Accident · Minor injuriesData collectionFinal reportCessna 182G · Silver City, NMThe pilot overcorrected when the airplane experienced a downdraft during the takeoff which resulted in the airplane stalling and impacting the terrain.Sep 27, 2014 · N2309R · Substantial damageNTSB CEN14LA520Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Albuquerque, NMThe pilot's failure to maintain main rotor rpm during a pinnacle approach, which resulted in a loss of helicopter control and collision with terrain. Contributing to the accident was the pilot's decision to attempt the approach given the helicopter's weight…Sep 26, 2014 · N7026J · Substantial damageNTSB WPR14CA392Accident · No injuriesData collectionFinal reportCirrus SR22 - NO Series · Elko, NVThe pilot's failure to maintain directional control during landing roll in gusty wind conditions, which resulted in a runway excursion and collision with terrain.Sep 25, 2014 · N73TW · Substantial damageNTSB ERA14CA458Accident · No injuriesData collectionFinal reportBeech C90 · Oneida, TNThe pilot's failure to properly configure the rudder trim for takeoff and his failure to maintain directional control during a precautionary landing, which resulted in a runway excursion and collision with terrain.Sep 25, 2014 · N211PC · Substantial damageNTSB WPR14CA391Accident · No injuriesData collectionFinal reportPiper PA 31T - II · Oakland, CAThe pilot's failure to extend the landing gear which resulted in a gear-up landing. Contributing to the accident was the pilot's failure to use the checklist and reported stress.Sep 24, 2014 · N774MF · Substantial damageNTSB WPR14CA389Accident · No injuriesData collectionFinal reportPiper PA25 - 260 · Mokuleia, HIThe pilot's improper preflight planning and reliance of fuel gauge readings, which resulted in a loss of engine power due to fuel exhaustion.Sep 24, 2014 · N8555L · Substantial damageNTSB WPR14CA388Accident · Serious injuriesData collectionFinal reportLundak Robert Kitfox IV · Sonoma, CAThe pilot's inadequate fuel management which resulted in an engine failure due to fuel starvation and subsequent collision with power lines during the forced landing.Sep 24, 2014 · N99FL · Substantial damageNTSB ANC14CA088Accident · No injuriesData collectionFinal reportPiper PA 12 · Holy Cross, AKThe pilot's selection of unsuitable terrain for takeoff/landing and failure to maintain control of the aircraft.Sep 24, 2014 · N3148M · Substantial damageNTSB WPR14CA385Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Mokuleia, HIThe pilot's failure to maintain aircraft control during landing with a quartering tailwind, which resulted in a hard landing.Sep 22, 2014 · N8375E · Substantial damageNTSB CEN14CA515Accident · Minor injuriesData collectionFinal reportCessna 150J · Brookfield, WIThe pilot's inadequate maintenance and preflight of the airplane which resulted in a total loss of engine power due to oil starvation.Sep 22, 2014 · N50889 · Substantial damageNTSB CEN14CA513Accident · No injuriesData collectionFinal reportSchweizer 269C · Grand Forks, NDThe flight instructor's inadequate supervision and delayed remedial action during a practice autorotation, which resulted in a tail rotor strike.Sep 22, 2014 · N1675U · Substantial damageNTSB ANC14LA085Accident · No injuriesLimited investigationFinal reportCessna TU206 · Deadhorse, AKThe application of insufficient torque to the engine cylinder through bolts during the replacement of the No. 1 cylinder, which resulted in the displacement of the No. 2 bearing, oil starvation, and a catastrophic engine failure.Sep 22, 2014 · N206J · Substantial damage