Skip to content

NTSB investigations: Cessna A188B, LA

39 cases on aircraft the registry lists as Cessna A188B. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19742026

Where

Latest cases

Query with SQL

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073005')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073005'))
  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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073005'))
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 DFW05CA216Accident · No injuriesData collectionFinal reportCessna A188B · Winnsboro, LAThe pilot's failure to maintain directional control during the take-off roll.Aug 15, 2005 · N4952Q · Substantial damage NTSB FTW01LA204Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Harrisonburg, LAloss of control during approach for an undetermined reason.Sep 6, 2001 · N2162J · Destroyed NTSB FTW00LA199Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Chase, LAThe failure of the pilot to maintain clearance with the deer stand. Factors were the chemical covering the windshield and the glare from the setting sun.Jul 9, 2000 · N731DW · Substantial damage NTSB FTW00LA166Accident · 1 fatalLimited investigationFinal reportCessna A188B · Pioneer, LAThe pilot's failure to maintain clearance with trees while maneuvering during an aerial application flight. A factor was the pilot's lack in experience with aerial application flight operations.Jun 1, 2000 · N70114 · Destroyed NTSB FTW99LA186Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Gheens, LAThe loss of engine power due to fuel starvation as result of a blocked fuel vent. A factor was the lack of suitable terrain for the forced landing.Jul 9, 1999 · N731AR · Substantial damage 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.Feb 13, 1999 · N8295G · Substantial damage NTSB FTW96LA338Accident · No injuriesLimited investigationFinal reportCessna A188B · Winnsboro, LAThe pilot's failure to maintain airspeed and altitude/clearance during the takeoff. A factor was the density altitude.Aug 7, 1996 · N92917 · Substantial damage NTSB FTW95LA332Accident · 1 fatalLimited investigationFinal reportCessna A188B · Fort Necessity, LAThe pilot's failure to maintain terrain clearance. A factor relating to the accident was: the gusty wind conditions.Aug 6, 1995 · N4866R · Destroyed NTSB FTW93LA196Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Edgard, LAThe pilot's attempt to takeoff under conditions that exceeded the performance capability of the aircraft. A factor was the high density altitude.Jun 25, 1993 · N9772G · Substantial damage 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.Aug 15, 1992 · N731AR · Substantial damage NTSB FTW90DRD15Accident · No injuriesFinal reportCessna 188 · Archibald, LAThe power loss for undetermined reasons. A factor was the rough uneven terrain in which the forced landing was performed.Aug 3, 1990 · N70114 · Substantial damage NTSB FTW88DRD15Accident · No injuriesFinal reportCessna A188B · Patterson, LAShortly after takeoff, the engine lost power & the plt dumped his load. Subsequently, the acft crash landed in a cane field. No preimpact mechanical problems could be found with the engine or fuel system. Water was found in the fuel tank outlet screen,…Jul 12, 1988 · N4825Q · Substantial damage NTSB FTW88DRD03Accident · 1 fatalFinal reportCessna 188 · Winnsboro, LAThe private pilot was practicing aerial application maneuvers with between 20 to 40 gallons of water in the spray tanks. A witness indicated that 'as the airplane started down for the pass it clearly went into a flat spin in which it made almost 2 full…May 15, 1988 · N78392 · Destroyed NTSB FTW87DRD01Accident · No injuriesFinal reportCessna A188B · Gilbert, LAThe acft was conducting aerial application operations when a decrease in fuel pressure and engine surging occurred. Examination failed to reveal a reason for the loss of fuel pressure and the subsequent surging of the engine. The emergency landing had to be…Oct 6, 1986 · N53137 · Substantial damage NTSB FTW83LA381Accident · No injuriesLimited investigationFinal reportCessna A188B · Plain Dealing, LAThe plt flew from his home base to Plain Dealing, LA to onload material for aerial application. During the landing roll-out, the right main gear leg failed. A metallurgical exam revealed the gear leg failed from fatigue which was initiated by corrosion pits…Aug 15, 1983 · N53282 · Substantial damage NTSB FTW83LA210Accident · No injuriesLimited investigationFinal reportCessna A188B · Winsboro, LAAprx 600 feet of the 2300 foot strip is concrete and the remainder is turf. According to the pilot, he raised the tail prior to running off the concrete. As the takeoff roll continued onto the turf, the acft veered sharply to the right. Full left rudder,…Apr 28, 1983 · N70203 · Substantial damage NTSB FTW82FRJ14Accident · Serious injuriesFinal reportCessna 188 · Monroe, LADuring turn around after first spray run, the aircraft collided with trees at an altitude of 75 feet. The path of flight was on a heading of 280 degrees, into the sun.Jul 24, 1982 · N9125G · Substantial damage NTSB FTW81FRD44Accident · Serious injuriesClosedCessna A188B · Port Barre, LASep 12, 1981 · N5632G · Destroyed NTSB FTW81FRJ31Accident · 1 fatalClosedCessna 188B · Winnsboro, LAAug 24, 1981 · N21685 · Destroyed NTSB FTW81DRD38Accident · No injuriesClosedCessna A188B · Labbadiville, LAAug 15, 1981 · N4952R · Substantial damage NTSB FTW81DRJ28Accident · No injuriesClosedCessna A188B · Bastrop, LAAug 7, 1981 · N731BR · Destroyed NTSB FTW80DRD57Accident · No injuriesClosedCessna 188B · Port Barre, LAAug 12, 1980 · N9230G · Destroyed NTSB FTW80DRJ23Accident · No injuriesClosedCessna 188B · Newellton, LAJun 8, 1980 · N731QD · Substantial damage NTSB FTW80DRJ20Accident · Minor injuriesClosedCessna 188 · Jonesville, LAMay 12, 1980 · N731UM · Substantial damage NTSB FTW79DRD56Accident · No injuriesClosedCessna 188B · Vacherie, LASep 24, 1979 · N9448G · Substantial damage NTSB FTW79DRJ10Accident · No injuriesClosedCessna A188B · Winnsboro, LAMar 6, 1979 · N8260G · Substantial damage NTSB FTW78DRJ28Accident · Minor injuriesClosedCessna 188 · Fondale, LAAug 13, 1978 · N70474 · Substantial damage NTSB FTW78FRJ20Accident · No injuriesClosedCessna A188B · Jones, LAJun 12, 1978 · N4806Q · Destroyed NTSB FTW78DRD35Accident · No injuriesClosedCessna 188B · De Ridder, LAJun 12, 1978 · N731HQ · Substantial damage NTSB FTW78DRD07Accident · Minor injuriesClosedCessna A188B · Le Blance, LANov 7, 1977 · N9313R · Destroyed NTSB FTW78DRJ01Accident · No injuriesClosedCessna A188B · Mansfield, LAOct 11, 1977 · N6380G · Substantial damage NTSB FTW78FRD02Accident · No injuriesClosedCessna A188B · De Ridder, LAOct 4, 1977 · N8125G · Substantial damage NTSB FTW77FRJ19Accident · Serious injuriesClosedCessna 188B · Mer Rouge, LAAug 23, 1977 · N91432 · Destroyed NTSB FTW77FRJ17Accident · No injuriesClosedCessna A188B · Oak Ridge, LAAug 20, 1977 · N9602G · Substantial damage NTSB FTW77FRJ07Accident · Serious injuriesClosedCessna 188B · Mer Rouge, LAMay 15, 1977 · N9305G · Destroyed NTSB FTW76FRJ43Accident · Serious injuriesClosedCessna A188B · Monroe, LASep 6, 1976 · N4838Q · Destroyed NTSB FTW75DRJ15Accident · Serious injuriesClosedCessna A188B · Simmesport, LASep 27, 1974 · N53375 · Destroyed NTSB FTW75FRJ07Accident · Minor injuriesClosedCessna A188B · Lk Providence, LAAug 20, 1974 · N9429G · Substantial damage NTSB FTW75DRJ03Accident · No injuriesClosedCessna 188B · Mer Rouge, LAAug 10, 1974 · N5706G · Substantial damage