NTSB investigations, LA
128 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 4 |
| 1984 | 10 |
| 1985 | 10 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 4 |
| 1989 | 5 |
| 1990 | 8 |
| 1991 | 2 |
| 1992 | 3 |
| 1993 | 5 |
| 1994 | 5 |
| 1995 | 4 |
| 1996 | 7 |
| 1997 | 6 |
| 1998 | 3 |
| 1999 | 6 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 9 |
| 2003 | 6 |
| 2005 | 10 |
| 2006 | 3 |
| 2007 | 4 |
Where
Open the mapLatest cases
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250) 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 DFW08FA053Accident · 1 fatalField investigationFinal reportBell 206L1 · Venice, LAThe pilot’s decision to continue to the destination landing platform in weather conditions below the company’s weather minimums and his failure to maintain aircraft control during the approach. Contributing to the passenger fatality and the severity of the…NTSB DFW08LA017Accident · No injuriesLimited investigationFinal reportRobinson R-22 · New Iberia, LAThe private pilot's failure to maintain main rotor rpm, which resulted in a hard landing and subsequent rollover. Also causal was the flight instructor's delayed remedial action. A factor was the lack of suitable terrain the forced landing.NTSB DFW07LA152Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-400 · Delhi, LAthe pilot's failure to maintain control of the airplane while practicing aerial application turns over a field.NTSB DFW07CA146Accident · No injuriesData collectionFinal reportSchweizer 269C · Slidell, LAThe pilot's encounter with settling with power condition while hovering out of ground effect. A contributing factor was the prevailing tailwind.NTSB DFW07FA008Accident · 1 fatalField investigationFinal reportNorth American T-28C · Georgetown, LAThe pilot's failure to maintain control of the airplane which led to an aerodynamic stall. A contributing factor was the dark night.NTSB DFW06CA190Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Woodworth, LAThe pilot's failure to maintain clearance from a tree. Contributing factors were the sudden wind shift and the gusty wind conditions.NTSB DFW06LA118Accident · Minor injuriesLimited investigationFinal reportEurocopter EC120B · Intracoastal, LAThe pilot's loss of control for undetermined reasons.NTSB DFW05LA239Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Orleans, LAThe pilot's failure to maintain directional control after encountering a loss of tail rotor effectiveness. A contributing factor was the lack of suitable terrain.NTSB DFW05LA252Accident · Minor injuriesLimited investigationFinal reportBell 206B · Myrtle Grove, LAThe pilot's loss of control in flight for undetermined reasons.NTSB DFW05CA212Accident · No injuriesData collectionFinal reportGrumman G164B · Alexandria, LAThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the high density altitude.NTSB DFW05CA191Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Gassoway, LAThe pilot's premature lift-off which resulted in an inadequate climb for terrain clearance. Also causal was the pilot's failure to abort the takeoff. A contributing factor was the high density altitude.NTSB DFW05FA170Accident · 5 fatalField investigationFinal reportBeech E90 · New Roads, LAThe pilot's failure to maintain airspeed and subsequent loss of control during a go-around maneuver.NTSB DFW05CA169Accident · No injuriesData collectionFinal reportRobinson R44 · Rayville, LAThe pilot's loss of control following an encounter with loss of tail rotor effectiveness. A contributing factor was the high density altitude.NTSB DFW05LA129Accident · 1 fatalLimited investigationFinal reportMiller Rand Robinson KR-2 · Galliano, LAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin during initial takeoff climb. A contributing factor was the pilot's lack of experience for the make/model airplane.NTSB DFW05LA102Accident · 2 fatalLimited investigationFinal reportSpearman Raptor · Bogalusa, LAThe pilot's failure to maintain control of the airplane. A contributing factor was the pilot's lack of experience in the make/model airplane.NTSB DFW05FA065Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Alexandria, LAThe pilot's loss of control while maneuvering to land.NTSB SEA05FA034Accident · 2 fatalField investigationFinal reportCessna 182R · Monroe, LAThe failure of the pilot manipulating the controls to maintain aircraft control during a night missed approach in instrument meteorological conditions. Factors include a dark night and low ceilings.NTSB FTW04IA077Incident · No injuriesIncident investigationFinal reportBell BH-212 · Galliano, LAThe loss of tail rotor control due to sheared, loose, and bent bolts which secured the tail rotor pitch control bellcrank support bracket.NTSB FTW03FA225Accident · 2 fatalField investigationFinal reportCessna 310J · New Orleans, LAThe pilot's failure to maintain aircraft control of the airplane during a go-around. A contributing factor was the crosswind.NTSB FTW03LA166Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Franklinton, LAThe pilot's encounter with dynamic rollover due to his failure to properly remove the tie-down strap on the right skid prior to takeoff. Factors were the pilot's inadequate preflight preparation and failure to abort takeoff.NTSB FTW03LA122Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Monroe, LAThe pilot's failure to maintain control of the helicopter. A contributing factor was the crosswind.NTSB CHI03FA056Accident · 1 fatalField investigationFinal reportBell 206L-1 · B.S. 53, LAThe improper approach by the pilot and the settling with power encountered by the pilot.NTSB FTW03FA071Accident · 2 fatalField investigationFinal reportGrumman American AA-1A · Shreveport, LAThe pilot's failure to maintain adequate airspeed resulting in a stall.NTSB FTW03FA027Accident · 3 fatalField investigationFinal reportAero Commander 500-B · Rayville, LAThe pilot-in-command's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.NTSB FTW03LA018Accident · No injuriesLimited investigationFinal reportCarriere RW-152 Scorpion II · Opelousas, LAThe pilot's inadequate compensation for wind resulting in a loss of control. A contributing factor was the gusting wind conditions.NTSB FTW02LA231Accident · Minor injuriesLimited investigationFinal reportPage Rans S-7 · Welsh, LAthe pilot's failure to maintain the minimum required airspeed for flight, which resulted in an inadvertent stall.NTSB FTW02LA221Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · New Roads, LAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin of the airplane.NTSB FTW02LA186Accident · Minor injuriesLimited investigationFinal reportBell 47G4 · Grand Lake, LAthe pilot's inability to control the helicopter in a hover due to the restricted movement of the cyclic for undetermined reasons.NTSB FTW02LA157Accident · No injuriesLimited investigationFinal reportGolden Circle Air T-Bird · Newellton, LAThe pilot's failure to maintain control of the airplane resulting in an inadvertant spin.NTSB FTW02FA113Accident · 2 fatalField investigationFinal reportBeech D-45 · Minden, LAThe private pilot's failure to maintain aircraft control during a go-around. Contributing factors were the private pilot's impairment due to drugs, the pilot-rated passenger's lack of experience in the airplane, and the prevailing gusty crosswind conditions.NTSB FTW02LA086Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Extension, LAThe pilot's failure to maintain aircraft control. A factor was the pilot's impairment due to drugs.NTSB FTW02FA062Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Oak Grove, LAthe pilot's failure to maintain control of the airplane while maneuvering resulting in an inadvertent stall/spin.NTSB FTW01LA204Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Harrisonburg, LAloss of control during approach for an undetermined reason.NTSB FTW01LA176Accident · No injuriesLimited investigationFinal reportSikorsky SK-76A · New Iberia, LAthe loss of control while maneuvering for undetermined reasons.NTSB FTW00LA266Accident · No injuriesLimited investigationFinal reportCessna 150K · New Orleans, LAThe pilot's failure to maintain control of the aircraft during an aborted landing. A factor was the crosswind.NTSB FTW00LA210Accident · 1 fatalLimited investigationFinal reportGrumman-Schweizer G-164B · Ville Platte, LAThe loss of control for an undetermined reason.NTSB FTW00LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Springhill, LAThe pilot's inadequate compensation for the wind conditions, which resulted in a loss of aircraft control. Factors were the gusty winds, and the pilot's inadequate weather evaluation.NTSB FTW00FA035Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · New Orleans, LAthe pilot's failure to maintain aircraft control which resulted in a stall/spin. A contributing factor was the dusk light condition.NTSB FTW99FA212Accident · 1 fatalField investigationFinal reportStanton Pitts S-1S · Coushatta, LAThe pilot's poor in-flight decision to perform aerobatics at a low altitude and slow airspeed, resulting in the inadvertent stall/spin.NTSB FTW99FA177Accident · 1 fatalField investigationFinal reportBeech V35 · Baton Rouge, LAThe pilot's performance of an abrupt maneuver immediately after takeoff, which resulted in an inadvertent stall.NTSB FTW99LA144Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Slidell, LAThe student pilot's delayed landing flare and her subsequent improper recovery technique following the bounced landing.NTSB FTW99LA101Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Jennings, LAThe pilot's inadvertent stall during the departure turn to downwind. A factor was the tailwind.NTSB FTW99LA039Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Braithwaite, LAThe pilot's inadvertent stall/spin. Factors were the terrain induced turbulence and the insufficient altitude for recovery.NTSB FTW99LA029Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Monroe, LAThe pilot's spatial disorientation which resulted in a loss of aircraft control. Factors were fog, low ceilings, and dark night conditions.NTSB FTW98LA194Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Oberlin, LAThe pilot's failure to maintain aircraft control. A factor was the gusty wind.NTSB FTW98LA058Accident · Serious injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Lecompte, LAa loose battery cover, due to improper installation by maintenance personnel, that became jammed with an elevator control rod and restricted the movement of the elevator control system, which subsequently led to an uncontrolled impact with a tree, shortly…NTSB FTW98LA030Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Welsh, LAthe pilot's failure to maintain control of the helicopter, while maneuvering to avoid an obstruction. The abrupt maneuver was a related factor.NTSB FTW97LA335Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Marksville, LAThe pilot's inadvertent stall during a turn to reverse direction during an aerial application flight. A factor was the pilot's chronic fatigue as result of cumulative long workdays.NTSB FTW97LA252Accident · Serious injuriesLimited investigationFinal reportBell 206B · New Iberia, LAthe pilot's improper in-flight planning/decision. A related factor was his failure to follow the company procedure of maintaining visual contact with the external long-line cable, while hovering with it attached.NTSB FTW97LA245Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400A · Church Point, LAThe pilot's improperly performed short field takeoff procedures.