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 WPR13LA358Accident · Minor injuriesLimited investigationFinal reportBell 206B · Chualar, CAMaintenance personnel's failure to properly tighten the bolts securing the main driveshaft to the transmission, which resulted in fatigue failure of the bolts and disconnection of the driveshaft during low-altitude flight.Aug 4, 2013 · N90146 · Substantial damageNTSB WPR13CA377Accident · No injuriesData collectionFinal reportAviat A-1B · West Jordan, UTThe pilot’s failure to maintain directional control during landing.Aug 4, 2013 · N211AM · Substantial damageNTSB ERA13LA363Accident · No injuriesLimited investigationFinal reportMooney M20R · Tallahassee, FLThe pilot's failure to troubleshoot the in-flight electrical problem and restore power using the operable redundant battery and his decision not to manually extend the airplane's landing gear, which resulted in a gear-up landing. Contributing to the accident…Aug 4, 2013 · N1034S · Substantial damageNTSB ERA13CA357Accident · No injuriesData collectionFinal reportPiper PA-34-200T · West Mifflin, PAThe pilot's improper landing flare, which resulted in a hard landing.Aug 4, 2013 · N75131 · Substantial damageNTSB ERA13CA352Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Erwinna, PAThe student pilot's improper altitude and energy management in the landing pattern which resulted in the glider impacting a tree and landing short of the runway.Aug 4, 2013 · N1211S · Substantial damageNTSB ERA13CA351Accident · No injuriesData collectionFinal reportCessna 170B · Meridian, MSThe pilot’s failure to maintain directional control during the landing roll.Aug 4, 2013 · N4251 · Substantial damageNTSB CEN13CA485Accident · No injuriesData collectionFinal reportCessna 150D · Hermleigh, TXThe pilot's improper positional awareness, which resulted in an off airport landing and impact with terrain.Aug 4, 2013 · N4281U · Substantial damageNTSB WPR13CA356Accident · No injuriesData collectionFinal reportCessna 170B · San Carlos, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Aug 3, 2013 · N8249A · Substantial damageNTSB ERA13FA348Accident · 3 fatalField investigationFinal reportBeech D55 · Conway, SCThe pilot's loss of airplane control, which resulted from his failure to follow the loss of single engine power checklist procedures after a total loss of right engine power due to fuel starvation. Contributing to the accident was the pilot's improper…Aug 3, 2013 · N7641N · DestroyedNTSB ERA13CA404Accident · No injuriesData collectionFinal reportCessna 172N · Knoxville, TNThe student pilot's improper flare and improper recovery from a bounced landing.Aug 3, 2013 · N737PD · Substantial damageNTSB ERA13CA350Accident · No injuriesData collectionFinal reportCessna 172S · Portsmouth, NHThe pilot’s inadequate preflight inspection resulting in his failure to remove the pin he used to lock the flight controls in place of the approved control lock.Aug 3, 2013 · N645PD · Substantial damageNTSB CEN13FA456Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Chesterfield, MOThe pilot’s failure to establish and maintain a positive climb rate during the initial climb in night instrument meteorological conditions.Aug 3, 2013 · N225CD · DestroyedNTSB CEN13CA458Accident · Minor injuriesData collectionFinal reportCessna R182 · Lago Vista, TXThe pilot’s inadequate recovery from a bounced landing in crosswind conditions, and an inadvertent aerodynamic stall during the subsequent go-around attempt.Aug 3, 2013 · N6370T · Substantial damageNTSB WPR13CA357Accident · No injuriesData collectionFinal reportChampion 7EC · Sonoma, CAThe pilot's failure to maintain directional control during the landing roll.Aug 2, 2013 · N4738E · Substantial damageNTSB WPR13CA355Accident · No injuriesData collectionFinal reportMooney M20F · Helena, MTThe flight instructor's delayed decision to instruct the pilot to abort the landing which resulted in a runway excursion and collision with a fence.Aug 2, 2013 · N2926M · Substantial damageNTSB ERA13CA353Accident · Minor injuriesData collectionFinal reportPiper/Cub Crafters PA-18-150 · Eagle Bay, NYThe pilot's failure to set the engine throttle to full power during a go-around.Aug 2, 2013 · N555AX · Substantial damageNTSB WPR13CA362Accident · No injuriesData collectionFinal reportBellanca 7GCBC · West Yellowstone, MTThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and a collision with an approach slope indicator system component.Aug 1, 2013 · N926BW · Substantial damageNTSB CEN13CA457Accident · No injuriesData collectionFinal reportStearman A75 · Appleton, WIThe pilot’s inadequate compensation for the crosswind, which resulted in a loss of directional control.Aug 1, 2013 · N234X · Substantial damageNTSB WPR13LA351Accident · Minor injuriesLimited investigationFinal reportStribling RV4 · San Manuel, AZThe pilot’s loss of directional control during takeoff with a tailwind, which resulted in a runway excursion.Jul 31, 2013 · N70AC · Substantial damageNTSB ERA13CA355Accident · No injuriesData collectionFinal reportBeech 58 · New Bedford, MAThe pilot's improper decision to land in the displaced threshold, resulting in a collision with the approach lighting system.Jul 31, 2013 · N58DL · Substantial damageNTSB CEN13LA454Accident · No injuriesLimited investigationFinal reportCessna 140 · Jonesboro, ARThe pilot's improper flare and recovery from a bounced landing and his delay in performing an aborted landing.Jul 31, 2013 · N2745N · Substantial damageNTSB CEN13CA453Accident · No injuriesData collectionFinal reportLuscombe 8A · Ellinwood, KSThe pilot failed to maintain directional control during takeoff.Jul 31, 2013 · N45957 · Substantial damageNTSB CEN13CA450Accident · No injuriesData collectionFinal reportCessna 172N · Mesquite, TXThe student pilot failed to maintain directional control during the touch-and-go landing and during the subsequent aborted takeoff during crosswind conditions.Jul 31, 2013 · N738RQ · Substantial damageNTSB WPR13LA349Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Billings, MTThe pilots’ inadequate landing flare, which resulted in a hard landing and collapse of the left main landing gear.Jul 30, 2013 · N5367Y · Substantial damageNTSB ERA13LA346Accident · Serious injuriesLimited investigationFinal reportFpna A-22 Valor · Wurtsboro, NYThe pilot’s failure to comply with the manufacturer’s limitations and guidance regarding flaperons usage at low altitude and in adverse wind conditions, which resulted in an in-flight loss of airplane control.Jul 30, 2013 · N912FP · Substantial damageNTSB WPR13LA347Accident · 1 fatalLimited investigationFinal reportAirborne Windsports PTY Edge XT-912-L · Red Bluff, CAThe pilot's failure to properly secure himself in the cockpit with the seat belt, which resulted in his inability to control the airplane after takeoff.Jul 29, 2013 · N123FJ · DestroyedNTSB ERA13TA341Accident · Serious injuriesFinal reportMcdonnell Douglas Helicopter 369E · Jackson, KYThe helicopter pilot's inadvertent collision with an unmarked and uncharted utility wire of which he was unaware.Jul 29, 2013 · N1608D · DestroyedNTSB ERA13FA340Accident · 1 fatalField investigationFinal reportFolland Gnat T 1 · Georgetown, SCThe loss of airplane control for reasons that could not be determined due to postcrash fire damage. Contributing to the accident was the pilot’s decision to perform an aerobatic maneuver at low altitude, which did not allow sufficient time for him to regain…Jul 29, 2013 · N18GT · DestroyedNTSB CEN13LA451Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400A · Lombardville, ILThe pilot's failure to maintain airplane control during takeoff.Jul 29, 2013 · N36612 · Substantial damageNTSB CEN13LA444Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Eagle Lake, MNThe pilot's misjudgment of tree heights, which resulted in the collision with a tree.Jul 29, 2013 · N8803Z · Substantial damageNTSB CEN13LA442Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M74A · Streator, ILThe pilot's diverted attention during an agricultural application maneuver, which resulted in the helicopter impacting a corn field.Jul 29, 2013 · N10009 · Substantial damageNTSB CEN13FA446Accident · 1 fatalField investigationFinal reportCampbell Earl S JR RV-6A · Knox, INThe incapacitation of the pilot due to a cardiovascular event that prevented him from maintaining control of the airplane during the landing approach.Jul 29, 2013 · N914ES · DestroyedNTSB ANC13CA069Accident · No injuriesData collectionFinal reportCessna A185E · Kotzebue, AKThe pilot's lack of situational awareness and failure to maintain adequate clearance from terrain during takeoff. Factors contributing to the accident was the check airmen’s inadequate supervision.Jul 29, 2013 · N4557F · Substantial damageNTSB WPR13LA346Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Lone Pine, CAA partial loss of engine power after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot's decision to not…Jul 28, 2013 · N82182 · Substantial damageNTSB WPR13CA345Accident · No injuriesData collectionFinal reportCessna 162 · Tacoma, WAThe pilot's improper level off/flare resulted in a hard landing/bounce and subsequent nose gear collapse.Jul 28, 2013 · N1205J · Substantial damageNTSB WPR13CA344Accident · Serious injuriesData collectionFinal reportPiper PA-18-135 · Quilcene, WAA loss of engine power due to the pilot's inadequate planning and mismanagement of the fuel supply, which resulted in fuel exhaustion.Jul 28, 2013 · N37JR · Substantial damageNTSB ERA13FA336Accident · 5 fatalField investigationFinal reportRobinson R66 · Noxen, PAThe pilot's decision to continue VFR flight into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.Jul 28, 2013 · N646AG · DestroyedNTSB ERA13CA338Accident · No injuriesData collectionFinal reportCessna 210M · Shirley, NYThe pilot's loss of control during an aborted takeoff as a result of his failure to properly configure the elevator trim prior to flight.Jul 28, 2013 · N450EM · Substantial damageNTSB CEN13LA455Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lafayette, INThe pilot’s failure to maintain adequate airspeed in gusting wind conditions during the initial climb after takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.Jul 28, 2013 · N286P · Substantial damageNTSB CEN13LA448Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · Capron, ILThe pilot's failure to maintain main rotor speed while maneuvering at low altitude during an agricultural application flight, which resulted in an uncontrolled descent into terrain.Jul 28, 2013 · N9681R · Substantial damageNTSB CEN13LA439Accident · 1 fatalLimited investigationFinal reportWoods Rufus III Vans RV-8A · Lucas, KSThe noninstrument-rated pilot's inadvertent entry into instrument meteorological conditions, which resulted in his spatial disorientation and a subsequent loss of airplane control.Jul 28, 2013 · N131RP · DestroyedNTSB WPR13FA343Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Thompson Falls, MTThe pilot's failure to maintain helicopter control while operating in conditions conducive to a loss of tail rotor effectiveness.Jul 27, 2013 · N25WH · Substantial damageNTSB ERA13LA343Accident · No injuriesLimited investigationFinal reportCessna 175 · Willimantic, CTThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.Jul 27, 2013 · N9388B · Substantial damageNTSB ERA13LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, GAThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the airplane's perceived lack of performance for reasons that could not be determined due to insufficient information.Jul 27, 2013 · N371JB · Substantial damageNTSB CEN13TA441Accident · Serious injuriesFinal reportCessna 182S · Tecumseh, OKThe pilot's inadvertent aerodynamic stall at a low altitude, which resulted in a loss of control and impact with terrain.Jul 27, 2013 · N820HP · Substantial damageNTSB CEN13FA438Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Lake Michigan, WIAn encounter with wake turbulence, which resulted in the pilot’s loss of control of the airplane and its subsequent in-flight breakup. Contributing to the accident was the approach controller’s failure to issue a wake turbulence advisory to the pilot.Jul 27, 2013 · N1549X · DestroyedNTSB CEN13CA449Accident · No injuriesData collectionFinal reportDean David E Kitfox Classic 4 · Grinnell, IAThe pilot did not maintain control of the airplane while landing with a crosswind.Jul 27, 2013 · N84SD · Substantial damageNTSB ANC13CA070Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Fairbanks, AKThe pilot's inadequate evaluation of his landing area, which resulted in contact with terrain.Jul 27, 2013 · N1467C · Substantial damageNTSB WPR13CA352Accident · No injuriesData collectionFinal reportCessna 180J · Hungry Horse, MTThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Jul 26, 2013 · N9286C · Substantial damageNTSB CEN13CA445Accident · No injuriesData collectionFinal reportCessna 170 · Burnet, TXThe pilot's improper recovery from a bounced landing.Jul 26, 2013 · N5401C · Substantial damage