NTSB investigations
1,269 cases where NTSB found Performance/control parameters, general.
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\", '01062000')) 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.
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", '01062000')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA19FA240Accident · 3 fatalClass 3 · FieldFinal reportBeech F33 · Hatboro, PAThe pilot's loss of airplane control due to spatial disorientation during the departure climb after entering instrument meteorological conditions.NTSB GAA19CA463Accident · No injuriesData collectionFinal reportHughes 269A · Springfield, TNThe pilot’s failure to maintain helicopter control and a loss of tail rotor effectiveness while hover-taxiing and turning toward a taxiway in gusting crosswind conditions, which resulted in a dynamic rollover.NTSB ERA19FA234Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Americus, GAThe pilot’s decision to depart in dark instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot’s and pilot-rated passenger’s self-induced pressure to…NTSB WPR19FA188Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Hayward, CAThe pilots’ loss of control during a low altitude maneuver for undetermined reasons, which resulted in impact with terrain.NTSB CEN19FA221Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Katy, TXThe pilot’s loss of airplane control and subsequent impact with terrain for reasons that could not be determined based on the available information.NTSB CEN19FA218Accident · 1 fatalField investigationFinal reportGIbb AR-1 · Hawley, MNAn in-flight loss of control and collision with terrain for reasons that could not be determined based on the available information.NTSB CEN19FA212Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Oxford, MSThe student pilot's failure to maintain airplane control during a go around with a tailwind, which resulted in an uncontrolled descent and impact with terrain.NTSB ERA19FA210Accident · 7 fatalClass 2 · FieldFinal reportAgusta AW139 · Big Grand Cay, BahamasThe pilots’ decision to takeoff over water in dark night conditions with no external visual reference, which resulted in spatial disorientation and subsequent collision with the water. Also causal was the pilots’ failure to adequately monitor their…NTSB CEN19MA190Accident · 10 fatalClass 2 · MajorFinal reportTextron B-300 · Addison, TXThe pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined. Contributing to the accident was the pilot’s failure to conduct the airplane…NTSB CEN19FA189Accident · 1 fatalField investigationFinal reportBeechcraft 58 · Hiawatha, KSThe pilot's loss of control for undetermined reasons.NTSB GAA19CA403Accident · Minor injuriesData collectionFinal reportMd Helicopter 369 · Summersville, SCThe copilot’s disabling of the flight controls of an operating helicopter without telling the pilot on the controls, which resulted in a subsequent loss of control and collision with terrain.NTSB GAA19CA327Accident · No injuriesData collectionFinal reportCessna 185 · Gulkana, AKThe pilot's loss of airplane control just before touchdown in gusting wind conditions, which resulted in ground loop after touchdown.NTSB GAA19CA328Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Monument, KSThe pilot's failure to maintain altitude due to distraction by ground equipment in the airplane’s path, which resulted in his failure to maintain clearance from crops during an agricultural application flight and resulted in a loss of airplane control.NTSB CEN19FA160Accident · 3 fatalClass 3 · FieldFinal reportRobinson R44 · Cass, ARA loss of engine power for reasons that could not be determined based on the available information.NTSB ANC19FA021Accident · 1 fatalClass 2 · FieldFinal reportBradshaw / McCauley Giles G-202 · Wasilla, AKThe pilot's failure to maintain control after the partial loss of engine power. Contributing to the accident was a contamination of the fuel system, which likely seized the electric fuel pump and restricted fuel flow to the engine.NTSB ERA19FA181Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28R · Auburn Township, OHThe pilot's loss of control due to spatial disorientation in dark night conditions. Contributing to the accident was his inadequate weather planning, lack of experience flying at night and the deteriorating weather conditions.NTSB CEN19FA155Accident · 1 fatalClass 3 · FieldFinal reportCessna R172 · Mertzon, TXThe pilot's loss of control due to spatial disorientation.NTSB CEN19LA150Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · McKinney, TXThe pilot's loss of control during an attempted go-around in gusting crosswind conditions.NTSB ANC19FA019Accident · 2 fatalClass 2 · FieldFinal reportDe Havilland DHC 2 · Metlakatla, AKThe pilot’s inadequate compensation for a quartering tailwind during a water landing, which resulted in a loss of control and subsequent nose-over. Contributing to the accident was the company’s inadequate operational control of the flight release process,…NTSB WPR19FA150Accident · 1 fatalClass 3 · FieldFinal reportBeech 35 · Melba, IDThe pilot's loss of control during a low-level aerobatic maneuver, which resulted in impact with terrain. Contributing to the accident was the pilot’s impairment due to the effects of alcohol and antidepressant medication.NTSB GAA19CA373Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Blairesville, GAThe pilot's failure to maintain airplane control during landing in gusting crosswind conditions, which resulted in a hard landing and landing gear collapse.NTSB CEN19FA144Accident · 1 fatalClass 2 · FieldFinal reportVans RV6 · Chillicothe, OHThe pilot's failure to maintain control of the airplane following an intermittent loss of engine power during cruise flight that resulted in him impacting trees. The reason for the loss of engine power could not be determined based on the available…NTSB WPR19FA148Accident · 2 fatalClass 3 · FieldFinal reportRobinson R44 · Alpine, UTThe noninstrument-rated pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control. Contributing to the accident was hypoxia due to the high altitude at which…NTSB CEN19FA143Accident · 1 fatalField investigationFinal reportBeech 60 · Loveland, COA loss of control due to an inflight right engine fire due to the loose fuel hose between the engine-driven fuel pump and the flow transducer.NTSB WPR19FA143Accident · 1 fatalClass 3 · FieldFinal reportTop Dog TopDog Ultralight · Creswell, ORThe non-certificated pilot's loss of control while maneuvering. Contributing to the accident was his lack of training in the aircraft and his impairment from illicit drugs.NTSB CEN19FA124Accident · 6 fatalClass 2 · FieldFinal reportBeech 58 · Kerrville, TXThe pilot's inadequate preflight fuel planning and fuel management, which resulted in a loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to follow the one-engine inoperative checklist and maintain the airplane's minimum…NTSB ERA19TA153Accident · No injuriesClass 3Final reportRobinson R22 · Bradenton Beach, FLThe pilot's improper decision to execute a low altitude turn that resulted in a strong tailwind and to reduce the airspeed to 0 knots and the flight instructor's diverted attention and inadequate monitoring, which resulted in the helicopter settling with…NTSB ERA19CA147Accident · Minor injuriesData collectionFinal reportGaskins Safari 400 · Gallatin, TNThe pilot/owner's improper decision to make a right turn instead of terminating the approach to a hover and his subsequent loss of helicopter control while attempting to land on sloping terrain, which resulted in a roll-over.NTSB WPR19FA103Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Farmington, NMThe noninstrument-rated pilot's continued visual flight rules flight into an area of forecast instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.NTSB GAA19CA186Accident · Serious injuriesData collectionFinal reportBell 206 · Valley Center, CAThe ground crew’s attachment of the load fill hose to the helicopter without telling the pilot, which resulted in a loss of helicopter control during takeoff.NTSB ERA19FA130Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Cashiers, NCThe pilot's loss of airplane control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.NTSB WPR19FA093Accident · 5 fatalClass 2 · FieldFinal reportPiper PA23 · Pahokee, FLThe pilot's failure to maintain control of the airplane while maneuvering for landing with one engine inoperative following a loss of engine power for reasons that could not be determined based on the available information.NTSB ERA19TA114Accident · Serious injuriesFinal reportRempe Kitfox · Merritt Island, FLThe pilot's failure to maintain airplane control during an attempted go-around.NTSB GAA19CA139Accident · No injuriesData collectionFinal reportAirbus A350 · Eureka, AKThe pilot's selection of unsuitable terrain for landing on snow-covered mountainous terrain with steep rocks above, which resulted in loose rocks damaging the main rotor blades and the subsequent loss of helicopter controllability.NTSB CEN19LA090Accident · No injuriesClass 2 · LimitedFinal reportBeech 400 · Richmond, INThe flight crew's decision to continue an unstable approach under conditions that exceeded the airplane's landing performance capabilities, which resulted in a runway overrun and impact with terrain.NTSB CEN19FA078Accident · 1 fatalClass 3 · FieldFinal reportMooney M20K · Katy, TXThe noninstrument-rated pilot's decision to continue visual flight into an area of instrument meteorological conditions (IMC), which resulted in a loss of control due to spatial disorientation.NTSB ANC19CA010Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA31 · Chignik Lagoon, AKThe pilot’s selection of an unsuitable runway for landing, which resulted in a loss of control and runway excursion.NTSB WPR19CA069Accident · No injuriesData collectionFinal reportChampion 7GCBC · Townsend, MTThe pilot's failure to maintain airplane control during a precautionary landing on an uneven, soft surface.NTSB CEN19LA065Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Uvalde, TXThe slipping of the sprag clutch due to galling of the sprags and corresponding sprag contact surfaces within the clutch assembly, which rendered the helicopter uncontrollable.NTSB GAA19CA124Accident · Serious injuriesData collectionFinal reportRobinson R44 · Santa Maria Island, FLThe pilot's loss of helicopter control while maneuvering at a low altitude after being struck in the head by a bird.NTSB GAA19CA085Accident · Minor injuriesData collectionFinal reportCessna 172 · St. Petersburg, FLThe pilot's failure to remove the gust lock before flight, which resulted in the airplane’s inability to rotate and a subsequent runway overrun. Contributing to the accident was the pilot’s failure to follow the preflight checklist.NTSB ERA19LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Barnesville, GAThe student pilot’s failure to maintain airplane control during takeoff and the flight instructor’s delayed remedial action, which resulted in an off-runway landing and subsequent collision with trees.NTSB ERA19LA043Accident · Serious injuriesClass 3 · LimitedFinal reportAero Commander 690 · Myrtle Beach, SCAn encounter with low-level windshear and turbulence during the landing approach, which resulted in a loss of airplane control.NTSB ERA19FA039Accident · 1 fatalField investigationFinal reportCessna 310 · Walton, NYAn in-flight fire of undetermined origin. Contributing to the accident were the severe icing conditions encountered during the final minutes of the flight, which led to a loss of airplane control.NTSB CEN19FA021Accident · 1 fatalField investigationFinal reportCessna 210 · Bradley, SDThe non-instrument-rated pilot's improper decision to conduct a flight in which instrument meteorological conditions existed along the route of flight, which resulted in spatial disorientation and a loss of airplane control.NTSB GAA19CA037Accident · No injuriesData collectionFinal reportZenith CH601 · Junction City, KSThe pilot's failure to secure the canopy latch before takeoff, which resulted in the canopy opening in flight and the subsequent loss of airplane control.NTSB ERA19LA012Accident · 3 fatalLimited investigationFinal reportPiper PA34 · Westhampton Beach, NYThe instructor's decision to conduct and continue a visual flight rules flight into instrument meteorological conditions with a known flight instrument anomaly, which resulted in spatial disorientation, causing a loss of airplane control and subsequent…NTSB ERA19FA010Accident · 1 fatalClass 2 · FieldFinal reportVans RV8 · Culpeper, VAThe pilot's loss of attitude orientation while maneuvering at low altitude in dark night visual meteorological conditions, which resulted in impact with terrain.NTSB CEN19FA004Accident · 2 fatalField investigationFinal reportPiper PA32RT · Poolville, TXThe pilot's loss of airplane control as a result of spatial disorientation and the exceedance of the structural capabilities of the airplane. Contributing to the accident was the pilot's limited experience in instrument conditions.NTSB ERA18FA251Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 · Woburn, MAThe pilots' loss of control during an instrument approach in instrument meteorological conditions as a result of spatial disorientation.