NTSB investigations, LA
72 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 6 |
| 1984 | 6 |
| 1985 | 3 |
| 1986 | 7 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 3 |
| 1993 | 4 |
| 1994 | 2 |
| 1996 | 3 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 3 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 1 |
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\" = 260)
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" = 260) 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 DFW06CA124Accident · No injuriesData collectionFinal reportRobinson R-44 · West Monroe, LAThe pilot's loss of control while taxiing.NTSB DFW05CA216Accident · No injuriesData collectionFinal reportCessna A188B · Winnsboro, LAThe pilot's failure to maintain directional control during the take-off roll.NTSB DFW05CA196Accident · No injuriesData collectionFinal reportCessna 120 · New Roads, LAThe pilot's failure to maintain control during the landing roll.NTSB DFW05CA084Accident · No injuriesData collectionFinal reportGrumman G-164A · Gilbert, LAThe pilot's failure to maintain control of the airplane during landing. A contributing factor was a deflated right main tire.NTSB DFW05CA008Accident · No injuriesData collectionFinal reportPiper PA-22 · Reserve, LAThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the strong crosswind.NTSB FTW04CA098Accident · No injuriesData collectionFinal reportStinson 108-1 · Slidell, LAthe pilot's failure to compensate for the gusty wind conditions and maintain control of the airplane while landing.NTSB CHI03FA259Accident · 3 fatalField investigationFinal reportBell 206L-3 · E.I. 276, LAThe inadequate compensation for crosswind conditions and the directional control not obtained/maintained by the pilot during takeoff. Contributing factors were the crosswind and the planned approach to position the helicopter with a crosswind in order to…NTSB FTW03LA136Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Batchelor, LAThe pilot's failure to abort the takeoff with adequate runway available. A contributing factor was the high density altitude.NTSB FTW03LA007Accident · No injuriesLimited investigationFinal reportMooney M20K · Port Sulphur, LAthe pilot's failure to maintain directional control while landing, which resulted in an in-flight collision with trees during an attempted go-around. A factor was the wet runway condition.NTSB FTW00LA227Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Rayville, LAThe flight instructor's failure to maintain directional control. A factor was the wind gusts.NTSB FTW00LA180Accident · No injuriesLimited investigationFinal reportCessna A185F · New Orleans, LAThe pilot's failure to maintain directional control during landing roll, which resulted in a ground loop.NTSB FTW00LA167Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G164B · Natchitoches, LAThe failure of the pilot to maintain directional control during the landing roll, which resulted in a ground loop. A factor was the crosswind.NTSB FTW99LA159Accident · No injuriesLimited investigationFinal reportLuscombe 8E · New Iberia, LAThe pilot's inadvertent ground loop.NTSB FTW99LA081Accident · No injuriesLimited investigationFinal reportCessna 188 · Alexandria, LAThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in an inadvertent ground loop.NTSB FTW99LA028Accident · No injuriesLimited investigationFinal reportCessna 185F · Venice, LAThe pilot's failure to maintain control of the airplane during high speed step-taxi. A factor was the swell left by the boat.NTSB FTW98LA141Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Rayville, LAThe pilot's inadequate compensation for the gusting crosswinds. Factors were the gusting crosswinds and the pilot's lack of experience in gusting crosswinds.NTSB FTW96LA333Accident · No injuriesLimited investigationFinal reportEmroth-Emair MA-1B · Clayton, LAThe pilot's failure to maintain directional control during the takeoff roll. A factor was the wet grass runway.NTSB FTW96LA159Accident · 1 fatalLimited investigationFinal reportWsk Pzl Mielec M-18A · Hughes, LAthe pilot exceeding the maximum authorized crosswind component of the airplane. Factors were the crosswind and the side sloping runway.NTSB FTW96LA103Accident · No injuriesLimited investigationFinal reportCessna A185F · Belle Chase, LAThe pilot's inadequate compensation for the wind conditions, which resulted in a loss of directional control and subsequent encounter with a ditch. The crosswind was a related factor.NTSB FTW95LA015Accident · No injuriesLimited investigationFinal reportCessna 185 · Abbeville, LAThe pilot's failure to compensate for wind conditions. A factor was the crosswind.NTSB FTW94LA093Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · Lake Charles, LAThe failure of the pilot to adequately perform a preflight. A factor was the soft terrain.NTSB FTW93LA254Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Oak Grove, LADirectional control not maintained by the pilot for undetermined reasons. Factors were a fence and trees.NTSB FTW93LA241Accident · No injuriesLimited investigationFinal reportCessna 140 · Bastrop, LAThe pilot's failure to maintain directional control and his improper compensation for existing wind conditions. Factors were the crosswind and the pilot's lack of total experience in the type of aircraft.NTSB DEN93LA045Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Shreveport, LAThe pilot's inadequate compensation for wind conditions. The gusty crosswind was a factor.NTSB FTW93LA110Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Abbeville, LAThe pilot's failure to compensate for crosswind conditions and the subsequent loss of directional control. Factors were the gusting crosswinds and the soft wet groundNTSB FTW92LA214Accident · No injuriesLimited investigationFinal reportCessna A185F · Amelia, LAThe pilot's selection of unsuitable terrain for takeoff.NTSB FTW92DRD06Accident · No injuriesFinal reportCessna A188B · Mathew, LAThe pilot's failure to maintain directional control of the aircraft. A factor was the pilot's lack of experience in the type operation.NTSB FTW92LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kinder, LAThe failure of the left brake which led to a loss of directional control. A factor was the rough terrain immediately adjacent to the runway.NTSB FTW92LA052Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Cottonport, LAThe pilot's failure to compensate for wind conditions. A factor was the crosswind.NTSB FTW92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-22 · New Roads, LAThe student pilot's loss of directional control and the resultant ground loop. Factors were the cfi's lack of supervision and the ditch adjacent to the runway.NTSB FTW91LA052Accident · Minor injuriesLimited investigationFinal reportMonocoupe D145 · Lafayette, LAThe pilot's failure to maintain directional control of the airplane.NTSB DEN91LA024Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Welsh, LAThe pilot's improper compensation for wind conditions. A factor was the gusty wind.NTSB FTW90FA170Accident · No injuriesField investigationFinal reportAir & Space 18A · Shreveport, LAFailure of the pilot in command to follow published takeoff procedures.NTSB FTW90LA163Accident · No injuriesLimited investigationFinal reportCessna 180 · Saint Joseph, LAThe pilot's failure to maintain directional control and his use of excessive braking.NTSB FTW90DRD03Accident · No injuriesFinal reportGrumman G-164A · Glynn, LALoss of directional control on the ground, due to intermittent locking of the right brake during the landing roll.NTSB FTW90IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Baton Rouge, LAThe captain's excessive speed during a turn off of the runway, and his failure to maintain directional control. The wet taxiway was a related factor.NTSB FTW89LA119Accident · No injuriesLimited investigationFinal reportCessna A185F · Marksville, LAFailure of the pilot to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and a subsequent nose over.NTSB FTW89DRD04Accident · No injuriesFinal reportSchweizer G-164A · Oak Grove, LAThe pilot failed to perform adequate prelight planning/preparation before attempting a takeoff by failing to assure the runway condition.NTSB FTW88LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Lake Charles, LABetween flights, the pilot noticed the nose was very high while taxiing but thought it was because the strut had failed to compress. On the next touchdown, on the main wheels, the airplane started porpoising and despite the pilot's corrections, the porpoising…NTSB FTW88LA116Accident · No injuriesLimited investigationFinal reportCessna 182L · Angola, LAThe pilot stated the airplane was on the takeoff roll when the seat slid to the rear. He was unable to control the airplane and it ran off the side of the runway and struck a fence. The seat track holes were worn enough that the locking pins would not stay in…NTSB FTW88LA043Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Woodworth, LAThe plt stated that during landing roll the aircraft veered left due to a strong wind gust. The aircraft fell into a ravine, coming to rest 180 degrees from the runway heading, damaging both wing spars at the fuselage attach points and collapsing the nose…NTSB FTW88LA031Accident · No injuriesLimited investigationFinal reportCessna 150 · New Orleans, LAThe pilot was attempting to start the unsecured aircraft by hand-propping it. The aircraft started and rolled forward striking a fuel truck, damaging the left wing, fuselage, and propeller.NTSB FTW87LA114Accident · No injuriesLimited investigationFinal reportAyres S2R-1820 · Ville Platte, LAAfter landing on a wet grass strip the pilot realized that the aircraft was not going to stop. Obstructions off the end of the runway prevented a go-around. The aircraft collided with two trees causing substantial damage.NTSB FTW87LA119Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Lake Providence, LAThe pilot, who reportedly was familiar with the 2200 x 90 foot sod strip, allowed the aircraft to drift left during the landing roll where the left main landing gear struck the end of a concrete culvert which did not extend quite to the extreme edge of the…NTSB FTW87DRD02Accident · No injuriesFinal reportCessna A-188-B · Ft.Polk, LAExamination revealed the tail wheel assembly was badly worn and its spacers were missing, causing the swivel mechanism to lock in the off center position. The aircraft landed on a narrow road. It veered slightly upon tail wheel contact and went off the…NTSB FTW86LRD23Accident · No injuriesFinal reportGrumman G-164B · Lecompte, LAThe plt was engaged in an aerial application flt when a thunderstorm developed to the southwest of the airstrip. The plt was attempting to land to the east before the storm hit. Control of the acft was lost after touchdown and the acft nosed over. A 25 to 40…NTSB FTW86LRD15Accident · No injuriesFinal reportGrumman G-164B · Church Point, LAThe acfts left wingtip caught in weeds during takeoff and the acft was pulled left. The plt had turned to avoid a wet spot on the airstrip and contacted the high weeds then swerved into a rice levee.NTSB FTW86LA105Accident · No injuriesLimited investigationFinal reportMaule M7-235 · New Orleans, LAThe plt lost directional control of the acft during the landing roll when he failed to compensate adequately for the x-wind resulting in a ground loop.NTSB FTW86LA101Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Timbalier, LADuring the ground run portion of a water take-off from a canal, the pilot encountered a strong gust of wind to the right of the aircraft nose. The pilot lost control of the aircraft and collided with an oil rig. The pilot failed to compensate for the…NTSB FTW86LA057Accident · No injuriesLimited investigationFinal reportCessna 185F · Point Aufer, LAThe pilot reported losing control of his aircraft, during takeoff from a canal at Point Aufer island, LA, when gusty wind conditions lifted a wing, causing the aircraft to collide with a bank. After the collision, the aircraft continued up onto the canal…