NTSB investigations, LA
86 cases where the sequence of events included Loss of control in flight.
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.\"eventStateOrRegion\" = 'LA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN13FA420Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Oak Ridge, LAThe private pilot’s and the flight instructor’s failure to maintain airplane control while performing agricultural operations turns low to the ground, which resulted in a stall/spin. Contributing to the accident was the private pilot’s impairment due to his…NTSB CEN13LA394Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Colfax, LAThe pilot’s failure to maintain clearance from a tree.NTSB CEN13FA326Accident · 1 fatalField investigationFinal reportHawker Beechcraft B200GT · Baker, LAThe pilot’s failure to maintain adequate airspeed during departure, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of specific knowledge of the airplane’s avionics.NTSB CEN13LA321Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Abbeville, LAFailure of maintenance personnel to ensure adequate torque of a tailrotor drive shaft coupling bolt, which resulted in the partial disconnection of the drive shaft.NTSB CEN13LA249Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Covington, LAThe pilot’s failure to maintain airspeed during a banner towing operation, which resulted in the airplane stalling and landing hard.NTSB CEN13CA246Accident · No injuriesData collectionFinal reportCessna 172N · New Orleans, LAThe pilot's failure to perform a steep climb before going around following a low pass for a banner tow pickup.NTSB CEN13FA192Accident · 3 fatalField investigationFinal reportSikorsky S-76A++ · Grand Lake, LAFracture of the red tail rotor blade spar, which resulted in the separation and departure of the red tail rotor blade from the helicopter and subsequent compromised tail gearbox. The red tail rotor blade was not recovered, thus the cause of the initial…NTSB CEN13LA163Accident · 1 fatalLimited investigationFinal reportPZL Mielec M-18A · Jennings, LAThe pilot’s inadequate visual lookout, which resulted in a collision with guy wires during an aerial application flight.NTSB CEN13FA143Accident · 4 fatalField investigationFinal reportRaytheon A36 · Richwood, LAThe pilot's failure to maintain control of the airplane during a missed approach in instrument meteorological conditions.NTSB CEN13LA072Accident · Serious injuriesLimited investigationFinal reportBeech S35 · DeRidder, LAA total loss of engine power due to oil starvation after the oil filler cap separated from the oil filler tube during flight due to corrosion. Contributing to the accident was the pilot's failure to maintain airspeed during low altitude operations, which…NTSB CEN13FA012Accident · 1 fatalField investigationFinal reportCessna 172R · Simpson, LAThe pilot’s loss of airplane control while maneuvering between areas of precipitation during a night cross-country flight.NTSB CEN13FA003Accident · 1 fatalField investigationFinal reportBell 407 · Intracoastal City, LAThe pilot’s decision to attempt a local flight in marginal visual meteorological conditions and his subsequent loss of control following an inadvertent encounter with instrument metrological conditions shortly after takeoff.NTSB CEN12FA611Accident · 1 fatalField investigationFinal reportFairley Gooch Lancair IV · Winnsboro, LAThe pilot’s failure to maintain control of the airplane after a loss of engine power during a go-around. Contributing to the accident was the difficult-to-operate fuel selector valve and the pilot’s continued operation of the airplane with a known mechanical…NTSB CEN12CA544Accident · Serious injuriesData collectionFinal reportSchweizer, N36289 G-164B · Kaplan, LAThe pilot's failure to maintain clearance from power lines during the aerial application flight.NTSB CEN12LA417Accident · Serious injuriesLimited investigationFinal reportBadeaux Challenger II · New Iberia, LAThe operation of an airplane by a noncertificated pilot and his failure to maintain clearance with the power lines during the landing approach.NTSB CEN12FA139Accident · 2 fatalField investigationFinal reportRobinson R44 II · Centerville, LAThe pilot allowed the helicopter to settle with power while maneuvering at low altitude.NTSB CEN12FA088Accident · 1 fatalField investigationFinal reportPiper PA-31 · New Orleans, LAThe pilot's fatal cardiac event, which resulted in the inflight loss of control of the airplane. Contributing to the accident was the pilot's use of impairing medications and operation of the airplane with disqualifying medical conditions.NTSB CEN11LA415Accident · Serious injuriesLimited investigationFinal reportBins Tom Kitfox IV · Lafayette, LAThe pilot’s loss of control during a forced landing after a loss of engine power for undetermined reasons during takeoff.NTSB CEN11CA580Accident · No injuriesData collectionFinal reportCessna 172N · Winnsboro, LAThe pilot's failure to maintain aircraft control during takeoff with a gusting crosswind.NTSB CEN11FA319Accident · 1 fatalField investigationFinal reportThomas Europa · Shreveport, LAThe loss of aircraft control and subsequent impact with terrain for undetermined reasons.NTSB CEN11LA283Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Lake Charles, LAThe pilot's loss of control of the helicopter while in a hover.NTSB CEN11CA231Accident · No injuriesData collectionFinal reportHiller UH-12D · Iowa, LAThe pilot's inadequate compensation for gusty crosswinds during takeoff, which resulted in a loss of directional control.NTSB CEN11FA115Accident · 3 fatalField investigationFinal reportCessna 182C · Crowley, LAA loss of engine power due to the magneto failure for undetermined reasons.NTSB CEN10CA417Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Shreveport, LAThe student pilot's failure to maintain control of the helicopter during takeoff, resulting in a loss of tail rotor effectiveness and a subsequent hard landing.NTSB CEN10IA397Incident · No injuriesIncident investigationFinal reportBell 206 · Gulf of Mexico, LAImproper reassembly of the collective flight controls by maintenance personnel. Contributing to the incident were inadequate postmaintenance examinations by maintenance personnel and inadequate preflight inspections by two pilots.NTSB CEN10FA011Accident · 2 fatalField investigationFinal reportCessna 150F · Alexandria, LAFailure of the wingman to maintain proper separation from the lead airplane during formation maneuvers. Contributing to the accident was lead's abrupt right bank and both pilots' lack of formation training.NTSB CEN09LA571Accident · Minor injuriesLimited investigationFinal reportMesserschmitt-Boelkow-Blohm BO-105S · Thibodaux, LAThe pilot's inability to maintain control due to the mechanic's inadvertent switching of two cyclic control tubes of different lengths during maintenance.NTSB CEN09LA299Accident · Serious injuriesLimited investigationFinal reportNorthwing Apache Sport · Franklinton, LAThe pilot's failure to maintain airspeed which resulted in a stall. Contributing to the accident was the pilot's lack of flight experience in the weight-shift trike.NTSB CEN09CA272Accident · Minor injuriesData collectionFinal reportCessna A185F · Patterson, LAThe pilot's failure to maintain adequate airspeed in a turn while attempting to return to land, which resulted in an aerodynamic stall. Contributing to the accident was the reported loss of engine power for undetermined reasons.NTSB CEN09LA255Accident · 1 fatalLimited investigationFinal reportWhitehead Titan · Slaughter, LAThe pilot's incorrect use of pitch control, resulting in induced pitch oscillations and loss of aircraft control. Contributing to the accident were the pilot's total lack of experience in aircraft make/model, and his lack of recency of experience.NTSB CEN09FA178Accident · 3 fatalField investigationFinal reportCessna 182M · Albany, LAThe pilot's loss of control of the airplane due to spatial disorientation after an encounter with marginal VMC and/or instrument meteorological conditions. Contributing to the accident was the pilot’s decision to attempt the flight with the preflight…NTSB CEN09MA117Accident · 8 fatalMajor investigationFinal reportSikorsky S-76C · Morgan City, LA(1) the sudden loss of power to both engines that resulted from impact with a bird (red-tailed hawk), which fractured the windshield and interfered with engine fuel controls, and (2) the subsequent disorientation of the flight crewmembers, which left them…NTSB DFW08CA195Accident · Minor injuriesData collectionFinal reportGrumman 164A · Lake Providence, LAThe pilot's failure to maintain control of the airplane while maneuvering during an aerial application. Contributing to the accident was the wind gust.NTSB DFW08CA168Accident · Minor injuriesData collectionFinal reportGrumman G-164 · Tallulah, LAThe pilot's failure to maintain aircraft control. Contributing to the accident was the pilot's failure to maintain adequate airspeed.NTSB DFW08FA080Accident · 2 fatalField investigationFinal reportCessna T210M · Abbeville, LAThe pilot's failure to maintain aircraft control for undetermined reasons. Contributing to the accident were the prevailing clouds, rain, and turbulence.NTSB DFW08CA075Accident · No injuriesData collectionFinal reportRobinson R-22 · Meraux, LAThe pilot's failure to ensure calculate weight and balance prior to flight. A contributing factor was the prevailing gusty winds.