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 GAA16CA477Accident · No injuriesData collectionFinal reportPacific Aerospace 750XL · Warrenton, VAThe pilot's failure to set the wing flaps for takeoff, which resulted in an aerodynamic stall, an aborted takeoff, and a runway overrun.Sep 9, 2016 · N750SS · Substantial damageNTSB ERA16CA314Accident · Minor injuriesData collectionFinal reportQuicksilver Manufacturing Sport 2S · Cleveland, GAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Sep 9, 2016 · N396DF · Substantial damageNTSB ANC16LA062Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland DHC-2 · Kodiak, AKThe pilot's failure to maintain adequate airspeed during the initial climb and turn after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.Sep 9, 2016 · N91AK · Substantial damageNTSB GAA16CA481Accident · Minor injuriesData collectionFinal reportStinson L 5 · San Antonio, TXThe pilot’s failure to maintain directional control during the landing roll.Sep 8, 2016 · N178 · Substantial damageNTSB GAA16CA470Accident · No injuriesData collectionFinal reportCessna 182 · Diller, NEThe pilot's failure to go around after overshooting his intended touchdown point, which resulted in impact with farm equipment and terrain during an aborted landing attempt.Sep 7, 2016 · N1928X · Substantial damageNTSB ERA16FA312Accident · 3 fatalField investigationFinal reportBeech F33 · Carrollton, GAThe failure of the Beech pilot to see and avoid the Diamond that was in front of and below his airplane on final approach and his use of an incorrect radio communication frequency for the airport.Sep 7, 2016 · N6027K · 2 aircraft · Substantial damageNTSB CEN16FA361Accident · 1 fatalField investigationFinal reportPiper PA 46-310P · Chariton, IAThe non-instrument-rated pilot's loss of control due to spatial disorientation in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations and a subsequent in-flight breakup. Contributing to the…Sep 7, 2016 · N465JM · Substantial damageNTSB GAA16CA512Accident · No injuriesData collectionFinal reportAir Tractor AT802 · Wilson, ARThe pilot’s failure to adequately survey the area of operation and his subsequent failure to maintain clearance from power lines during an agricultural application flight.Sep 6, 2016 · N519EP · Substantial damageNTSB GAA16CA469Accident · Minor injuriesData collectionFinal reportRainbow Sky Reach Bushcat · Frankfort, KYThe pilot's exceedance of the airplane's critical angle-of-attack while maneuvering at low altitude, which resulted in an aerodynamic stall.Sep 6, 2016 · N2899X · Substantial damageNTSB ERA16FA311Accident · 3 fatalField investigationFinal reportSikorsky S61 · Palm Bay, FLA dual loss of engine power for undetermined reasons after the pilot's improper decision to attempt another maneuver after recovering from a perceived compressor stall, rather than returning to the airport.Sep 6, 2016 · N805AR · DestroyedNTSB GAA16CA478Accident · No injuriesData collectionFinal reportCessna 180 · Clemson, SCThe pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion.Sep 5, 2016 · N451SW · Substantial damageNTSB GAA16CA467Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Atlanta, TXThe pilot's failure to attain the proper touchdown point on a grass airstrip and the airplane's subsequent collision with trees during an attempted aborted landing.Sep 5, 2016 · N52236 · Substantial damageNTSB GAA16CA465Accident · No injuriesData collectionFinal reportCessna TR182 · South Lake Tahoe, CAThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion and a nose over. Contributing to the accident was the pilot's failure to remove the carburetor heat during the attempted go-around in high…Sep 5, 2016 · N738GK · Substantial damageNTSB GAA16CA462Accident · No injuriesData collectionFinal reportAir Tractor AT · Hondo, TXThe pilot’s failure to maintain clearance from an antenna atop a tower while maneuvering at a low altitude and the airplane’s subsequent impact with terrain during an attempted off-airport landing.Sep 5, 2016 · N31627 · Substantial damageNTSB GAA16CA486Accident · No injuriesData collectionFinal reportChampion 7GC · Palmer, AKThe pilot’s inadequate preflight inspection and failure to assess the airplane’s fuel quantity before departure, which resulted in fuel exhaustion.Sep 4, 2016 · N4831E · Substantial damageNTSB GAA16CA479Accident · No injuriesData collectionFinal reportSchleicher ASW 27 · Benton, TNThe glider pilot's descent below the glidepath and the subsequent hard, off-airport landing.Sep 4, 2016 · N27BZ · Substantial damageNTSB CEN16LA352Accident · No injuriesLimited investigationFinal reportCameron Z90 · Morrill, NEThe pilot’s improper inflight fuel management, which resulted in fuel exhaustion and an inability to avoid contact with power lines.Sep 4, 2016 · N982ZS · Substantial damageNTSB CEN16FA346Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Moss Hill, TXThe pilot's loss of control attempting to recover from a low-level aerobatic maneuver. Contributing to the accident was the pilot's decision to attempt the low-level maneuver which significantly reduced any margin for error.Sep 4, 2016 · N787MW · Substantial damageNTSB GAA16CA507Accident · No injuriesData collectionFinal reportStropki Paul Outback · Dalton, OHThe pilot's failure to maintain directional control of the airplane during landing in gusting wind conditions, which resulted in a ground loop.Sep 3, 2016 · N56P · Substantial damageNTSB GAA16CA485Accident · Minor injuriesData collectionFinal reportDormaier Monte R Baby Great Lakes · Mazama, WAThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion.Sep 3, 2016 · N110MD · Substantial damageNTSB GAA16CA474Accident · No injuriesData collectionFinal reportCessna 180 · Yakutat, AKThe pilot's inadequate inspection of the off-airport landing area, which resulted in an encounter with standing water and a nose over.Sep 3, 2016 · N54AF · Substantial damageNTSB GAA16CA468Accident · No injuriesData collectionFinal reportMaule M4 · Talkeetna, AKThe pilot's failure to recognize and compensate for tailwind conditions during the landing roll, which resulted in a runway overrun and nose over.Sep 3, 2016 · N40661 · Substantial damageNTSB GAA16CA464Accident · No injuriesData collectionFinal reportNorth American SNJ · Perris, CAThe pilot's inability to compensate for a dust devil during an aborted landing, which resulted in the left wing contacting the ground, a runway excursion, and the airplane coming to rest in a nose-down attitude.Sep 3, 2016 · N7296C · Substantial damageNTSB GAA16CA463Accident · No injuriesData collectionFinal reportCessna 182 · Barrow, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, a nose over, and substantial damage to the right wing strut and fuselage. Contributing to the accident was the sun glare which inhibited the…Sep 3, 2016 · N9928T · Substantial damageNTSB ERA16FA309Accident · 2 fatalField investigationFinal reportCessna 172 · Hollywood, FLThe pilot's inadequate preflight and in-flight weather planning, which resulted in continued flight into a thunderstorm and a subsequent loss of airplane control.Sep 3, 2016 · N6091E · DestroyedNTSB CEN16LA363Accident · Serious injuriesLimited investigationFinal reportCGS Hawk Aero II · Holland, MIThe improper installation of quick release connectors in the fuel lines, which was not in accordance with the engine manufacturer's maintenance instructions and allowed air to be introduced into the fuel system and resulted in a partial loss of engine power.…Sep 3, 2016 · N4513S · DestroyedNTSB CEN16LA347Accident · 1 fatalLimited investigationFinal reportHaggenmacher Bensen · Bryant, ARThe pilot’s loss of gyroplane control during an intentional high-speed pass, which resulted in the gyroplane porpoising and impacting terrain. Contributing to the accident was the pilot’s decision to conduct the flight in an aircraft in which he had little…Sep 3, 2016 · UNREG · DestroyedNTSB WPR16LA175Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 500N · Honolulu, HIThe pilot's failure to maintain helicopter control in gusting wind conditions, which resulted in the helicopter rescue net’s contact with a utility pole and serious injury to an occupant who fell from the rescue net. Contributing to the accident was the…Sep 2, 2016 · N5232G · No damageNTSB GAA16CA529Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Delaware, OHThe student pilot’s inadequate compensation for the quartering tailwind on landing, which resulted in a loss of directional control.Sep 2, 2016 · N904LA · Substantial damageNTSB CEN16FA344Accident · 2 fatalField investigationFinal reportAves Douglas James RV 6 · Viborg, SDThe pilot's failure to maintain airplane control, which resulted in the airplane exceeding its critical angle of attack, an aerodynamic stall, and subsequent flat spin into terrain.Sep 2, 2016 · N676DT · DestroyedNTSB ERA16CA313Accident · No injuriesData collectionFinal reportBell Helicopter Textron Canada 429 · Rikers Island, NYThe pilot’s overcontrolling of the helicopter during an aborted slope landing from a hover, which resulted in a main rotor blade strike.Sep 1, 2016 · N917PD · Substantial damageNTSB WPR16FA172Accident · 2 fatalField investigationFinal reportBeech A36 · Sparks, NVThe pilot's selection of a landing runway which, given the wind and traffic conditions, was susceptible to high crosswinds and the translation of wake turbulence across its approach path, and the controller's and pilot's failure to ensure separation from the…Aug 31, 2016 · N985CA · DestroyedNTSB CEN16LA343Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Hibbing, MNThe pilot's failure to maintain aircraft control, which resulted in impact with terrain near the runway.Aug 31, 2016 · N1726D · Substantial damageNTSB CEN16FA341Accident · 1 fatalField investigationFinal reportBeech A36 · Bentonville, ARThe pilot's failure to monitor and/or transmit his position over the uncontrolled airport's common traffic advisory frequency, and his decision to continue the takeoff when he observed conflicting traffic on the runway.Aug 31, 2016 · N8283D · DestroyedNTSB ANC16FA061Accident · 5 fatalField investigationFinal reportCessna 208 · Russian Mission, AKThe failure of both pilots to see and avoid each other while in level cruise flight, which resulted in a midair collision.Aug 31, 2016 · N752RV · 2 aircraft · DestroyedNTSB GAA16CA496Accident · No injuriesData collectionFinal reportCessna 172 · Delta, UTThe student pilot’s improper landing flare, which resulted in a hard, porpoised landing.Aug 30, 2016 · N734AV · Substantial damageNTSB GAA16CA461Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Sedona, AZThe pilot’s failure to maintain directional control during the landing in gusting wind conditions, which resulted in a runway excursion.Aug 30, 2016 · N114LC · Substantial damageNTSB GAA16CA460Accident · No injuriesData collectionFinal reportCessna 172 · Winchester, VAThe student pilot's incorrect pitch control during the landing flare, which resulted in a porpoise, a loss of directional control, and a runway excursion.Aug 30, 2016 · N2462E · Substantial damageNTSB GAA16CA459Accident · No injuriesData collectionFinal reportCessna A185 · Gooding, IDThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.Aug 30, 2016 · N185TJ · Substantial damageNTSB CEN16LA355Accident · Serious injuriesLimited investigationFinal reportRepublic RC3 · Post Oak, MOA partial loss of engine power due to low cylinder compression. Contributing to the loss of engine power was rust formation in the cylinders due to inactivity.Aug 30, 2016 · N6490K · Substantial damageNTSB CEN16LA342Accident · No injuriesLimited investigationFinal reportFairchild M 62A-3 · Madison, OHThe pilot's failure to follow the Before Takeoff checklist and his improper use of flaps during takeoff, which degraded the airplane's climb performance and resulted in a collision with trees.Aug 30, 2016 · N47164 · Substantial damageNTSB CEN16CA364Accident · No injuriesData collectionFinal reportBeech V35B · Sioux Falls, SDThe pilot's failure to adequately manage the available fuel supply, resulting in fuel starvation and a total loss of engine power. Contributing to the accident was the inadequate preflight by the pilot and flight instructor, and the flight instructor's…Aug 30, 2016 · N23583 · Substantial damageNTSB ERA16CA308Accident · No injuriesData collectionFinal reportBeech C23 · Simsbury, CTThe student pilot’s failure to attain the proper touchdown point, which resulted in a runway overrun.Aug 29, 2016 · N9352S · Substantial damageNTSB CEN16LA354Accident · No injuriesLimited investigationFinal reportNorth American Navion · Monett, MOMaintenance personnel’s failure to properly rig the right main landing gear locking mechanism, which resulted in a gear collapse during landing.Aug 29, 2016 · N91488 · Substantial damageNTSB WPR16FA170Accident · 2 fatalField investigationFinal reportCessna 182 · Clinton, MTThe sudden right turn on approach to landing for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Aug 28, 2016 · N9936T · DestroyedNTSB CEN16LA338Accident · 2 fatalLimited investigationFinal reportCessna 172 · New Orleans, LAThe pilot's improper decision to continue a descent during a night visual approach a for landing which resulted in controlled flight into terrain. Contributing to the accident was the reduced visibility and pilot's disregard of the PAPI indications that the…Aug 28, 2016 · N984RA · Substantial damageNTSB WPR16FA169Accident · 1 fatalField investigationFinal reportBoeing A75N1(PT17) · Madras, ORThe pilot's failure to maintain clearance from the runway during a low-level aerobatic maneuver. Contributing to the accident was a high density altitude and the pilot's failure to plan/adequately compensate for high density altitude conditions.Aug 27, 2016 · N999PP · DestroyedNTSB GAA16CA456Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot's improper soft field landing technique on a soft grass airstrip, which resulted in a nose over.Aug 27, 2016 · N7184B · Substantial damageNTSB ERA16CA304Accident · No injuriesData collectionFinal reportCessna 195 · Livermore Falls, METhe pilot's failure to maintain directional control during landing roll out.Aug 27, 2016 · N4352V · Substantial damageNTSB ANC16LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA 18-150 · Salcha, AKThe pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in an in-flight collision with terrain.Aug 27, 2016 · N8998Y · Substantial damage