Cessna 188B
NTSB investigations · 28
Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.aircraft_model_code IN ('2073007')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2073007')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 GAA19CA008Accident · Minor injuriesData collectionFinal reportCessna 188 · Rolla, MOThe pilot's failure to maintain directional control during takeoff in a left quartering tailwind.NTSB ERA13LA410Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Woodrow, SCA failure of the right rudder pedal arm due to corrosion as a result of inadequate maintenance and inspection of the rudder pedal assembly.NTSB CHI04LA120Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Pleasant Hill, MOFuel exhaustion due to the pilot's improper fuel calculations. Contributing factors to the accident included the inaccurate fuel gage and the trees.NTSB CHI03LA265Accident · No injuriesLimited investigationFinal reportCessna 188B · Monette, ARFailure of the right brake and the pilot's inability to maintain directional control. A factor associated with the accident was the ditch.NTSB MIA02CA174Accident · Minor injuriesData collectionFinal reportCessna 188B · Pikesville, NCThe inability of the pilot to see the .250 inch diameter unmarked cable resulting in the in-flight collision with the cable and substantial damage to the airplane.NTSB MIA01LA178Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Leesburg, FLThe pilot's failure to maintain a visual lookout while deploying the grappling hook in preparation for a banner pick up resulting in the cable wrapping around the stabilizer, subsequent loss of control during the banner drop (due to the cable moving forward…NTSB MIA00LA233Accident · No injuriesLimited investigationFinal reportCessna 188B · Washington, NCa loss of engine power for undetermined reason, resulting in a forced landing, and subsequent impact with a ditch.NTSB CHI98LA214Accident · No injuriesLimited investigationFinal reportCessna 188B · South Haven, MIthe pilot misjudging his distance and not maintaining the proper altitude. A factor was trees.NTSB CHI97LA273Accident · No injuriesLimited investigationFinal reportCessna 188B · South Haven, MIfailure of a connecting rod in the engine assembly, which resulted in loss of engine power and a forced landing. Factors relating to the accident were: lack of a recommended engine overhaul, and the lack of suitable terrain for an emergency landing.NTSB MKC88LA143Accident · No injuriesLimited investigationFinal reportCessna 188 · York, NEEn route to perform an aerial application operation, the plt said he experienced a partial power loss followed by complete power failure. He attempted an emergency ldg in a farm cornfield, substantially damaging the acft. An on scene investigation by the FAA…NTSB ATL84LA167Accident · No injuriesLimited investigationFinal reportCessna 188B · Paxville, SCThe acft nosed over short of the rwy after the engine failed to respond to the plts attempt to add power to reach the rwy. It was found after the accident that the carb heat control door brackets were worn which allowed the butterfly valve door to separate…NTSB FTW80FPJ36Accident · Serious injuriesClosedCessna 188B · Altus, OKNTSB SEA78FTI25Accident · No injuriesClosedCessna A188B · Chester, MTNTSB FTW78DPJ17Accident · Minor injuriesClosedCessna 188 · Braman, OKNTSB FTW77DRA31Accident · No injuriesClosedCessna 188B · Clay, TXNTSB CHI77FET26Accident · Minor injuriesClosedCessna 188B · Coloma, MINTSB MIA76FKQ42Accident · No injuriesClosedCessna 188B · Picayune, MSNTSB CHI76FET34Accident · Minor injuriesClosedCessna 188B · Union, MINTSB MIA75ALG15Accident · Minor injuriesClosedCessna 188B · Barnwell, SCNTSB FTW75DPG69Accident · Minor injuriesClosedCessna 188B · Elaine, ARNTSB DEN75DTE61Accident · No injuriesClosedCessna 188B · Greeley, CONTSB MIA74FLD43Accident · No injuriesClosedCessna A188B · Zellwood, FLNTSB FTW74FPG19Accident · Serious injuriesClosedCessna 188 · Marvell, ARNTSB IAD74AI013Accident · 1 fatalClosedCessna 188B · Swan Quarter, NCNTSB MIA73DLT06Accident · No injuriesClosedCessna 188A · Dundee, MSNTSB FTW73FPG22Accident · No injuriesClosedCessna 188B · Marvell, ARNTSB MIA73DKJ01Accident · No injuriesClosedCessna 188 · Prattville, ALNTSB CHI72FET33Accident · 1 fatalClosedCessna 188A · South Bend, IN
Back to Cessna 188B