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 ('2073002')
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 ('2073002')
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 CEN18LA311Accident · No injuriesLimited investigationFinal reportCessna 188 · Watkins, MNA partial loss of engine power for reasons that could not be determined because a postaccident examination revealed no evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA15CA089Accident · No injuriesData collectionFinal reportCessna 188 · Polson, MTThe pilot's failure to maintain airplane pitch, power, and turn coordination while maneuvering at low altitude, resulting in an aerodynamic stall and a collision with terrain.NTSB CEN14LA432Accident · No injuriesLimited investigationFinal reportCessna 188 - Undesignat · Columbus, NMThe pilot’s failure to release the load of agricultural product before the landing approach and his failure to maintain aircraft control during an initial climb after an aborted landing, which resulted in the airplane exceeding its critical angle of attack…NTSB ERA12CA116Accident · No injuriesData collectionFinal reportCessna 188 · Starkville, MSThe pilot did not maintain directional control of the airplane during landing, which resulted in a runway excursion.NTSB WPR11CA296Accident · Minor injuriesData collectionFinal reportCessna 188 · Glasgow, MTThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ATL99LA005Accident · No injuriesLimited investigationFinal reportCessna 188 · Patrick, SCThe failure of the number 2 piston for undetermined reasons.NTSB CHI96LA282Accident · No injuriesLimited investigationFinal reportCessna 188-230 · Santanta, KSa loss of power due to a broken number four cylinder exhaust valve push rod and a bent number four cylinder intake valve push rod. The wet, soft cornfield was a factor.NTSB CHI95LA122Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Meade, KSthe pilot taking off the airplane at a low liftoff speed (Vlo). A factor associated with the accident was a stall/mush encountered by the pilot.NTSB SEA93LA171Accident · No injuriesLimited investigationFinal reportCessna 188 · Marion, MTThe premature liftoff for takeoff by the pilot and the inadvertant stall/mush. A factor relating to the accident was the high density altitude.NTSB ATL92LA104Accident · 1 fatalLimited investigationFinal reportCessna 188 · Elba, ALThe pilot's failure to maintain clearance from objects (trees), and his inadequate visual lookout. A factor was the trees located in the practice area.NTSB CHI90DTG01Accident · No injuriesFinal reportCessna 188 · Dazey, NDA blockage of the fuel tank vent line. Contributing to the accident was the unsuitable terrain on which the pilot had to make the forced landing.NTSB FTW89DRD15Accident · Serious injuriesFinal reportCessna 188 · Winnsboro, LAThe pilot's inadequate visual lookout and subsequent collision with a tree.NTSB MKC87DCQ02Accident · Serious injuriesFinal reportCessna 188 · Harper, KSThe pilot was preparing to spray a wheatfield. During the second 1/3 of procedural turnaround, the aircraft struck powerlines, then the ground. The aircraft was destroyed by post-impact fire.NTSB MKC86LA106Accident · No injuriesLimited investigationFinal reportCessna 188 · Lawrence, KSThe pilot stated that the right main tire rolled over sharp rocks and was subsequently destroyed during the takeoff roll. The pilot further stated that he apparently over corrected and drifted left, digging into a soft spot on the runway, and nosed over.NTSB MKC84FA245Accident · Serious injuriesField investigationFinal reportCessna 188 · Bloom, KSThe acft struck two guy wires during a spraying operation when the plt failed to clear the wires. Operators heard the impact which occurred about 160 AGL & toppled the 310 ft tower. The acft wings were separated from the fuselage which continued to the west…NTSB MKC84LA193Accident · No injuriesLimited investigationFinal reportCessna 188 · Dyersville, IAThe acft was over max gross wt by aprx 147 lbs and exceeded the fwd CG limit with a 1200 lb chemical load. During the initial climb at 50-100 ft AGL the acft could not maintain flying speed, stalled, and entered an uncontrolled descent. The acft impacted…NTSB FTW84LA176Accident · No injuriesLimited investigationFinal reportCessna 188 · Clayton, LADuring the last landing of the day in a gusty crosswind, the acft went off the side of the rwy and nosed down in a plowed field. This was the plts 26th landing for this day, all on the same rwy. The wind was gusting to 20 KTS.NTSB ATL83LA361Accident · No injuriesLimited investigationFinal reportCessna 188 · Slocomb, ALThe plt stated that he pulled up from a swath run and the eng began loosing power. He climbed to 300 ft & started back to the airstrip, then a total power loss occurred. During an emergency landing, he was unable to stop before the acft collided with trees at…NTSB ATL82FID08Accident · No injuriesFinal reportCessna 188 · West Point, VAThe pilot took off with a 50 gal load of water to calibrate the spray system. He stated that during a swath run, he heard a loud noise or whirring sound and initially thought there was a spray pump propeller failure. Immediately, he pulled up, started a left…NTSB DEN81FTA09Accident · No injuriesClosedCessna 188 · Flaxville, MTNTSB FTW81DRA40Accident · No injuriesClosedCessna A188B · Louise, TXNTSB MKC81FCJ15Accident · 1 fatalClosedCessna 188 · Firth, NENTSB FTW81FPJ12Accident · Serious injuriesClosedCessna 188 · Blackwell, OKNTSB CHI80FER63Accident · Minor injuriesClosedCessna 188 · Long Prairie, MNNTSB MKC80DCJ23Accident · No injuriesClosedCessna 188 · Blue Hill, NENTSB FTW79FPD45Accident · No injuriesClosedCessna 188 · Henrietta, TXNTSB FTW78FRG49Accident · Minor injuriesClosedCessna A188B · Woodsboro, TXNTSB MIA77FLA54Accident · 2 fatalClosedCessna 188-B · Nashville, GANTSB IAD77DKW28Accident · No injuriesClosedCessna 188 · Charlotte, TNNTSB MIA77FLG30Accident · No injuriesClosedCessna 188 · Edgemoor, SCNTSB MKC77DCQ52Accident · No injuriesClosedCessna 188 · Meade, KSNTSB FTW77FPG66Accident · No injuriesClosedCessna 188 · Brookland, ARNTSB FTW77DRG50Accident · No injuriesClosedCessna 188 · Fowlerton, TXNTSB FTW77DQG22Accident · No injuriesClosedCessna 188 · Panhandle, TXNTSB MIA76DKK01Accident · No injuriesClosedCessna 188 · Huntsville, ALNTSB MIA76FKJ93Accident · No injuriesClosedCessna 188 · Geneva, ALNTSB FTW76DRA51Accident · No injuriesClosedCessna 188 · Madisonville, TXNTSB CHI76FEI35Accident · No injuriesClosedCessna 188 · Wooster, OHNTSB MIA76FKJ79Accident · No injuriesClosedCessna 188 · Enterprise, ALNTSB MKC76FER70Accident · No injuriesClosedCessna 188 · Baudette, MNNTSB FTW76DPD45Accident · No injuriesClosedCessna 188 · Bowie, TXNTSB MIA76FKQ28Accident · No injuriesClosedCessna 188 · Webb, MSNTSB MKC76FCJ07Accident · No injuriesClosedCessna 188 · Auburn, NENTSB CHI76DEP12Accident · No injuriesClosedCessna 188 · Gillman, WINTSB LAX75AVA55Accident · Serious injuriesClosedCessna 188 · Lost Hills, CANTSB FTW75DPG43Accident · No injuriesClosedCessna 188 · Jonesboro, ARNTSB FTW75DQG45Accident · No injuriesClosedCessna 188 · Panhandle, TXNTSB MIA75FKQ20Accident · Serious injuriesClosedCessna 188 · Philadelphia, MSNTSB FTW75FPG14Accident · Serious injuriesClosedCessna 188 · Dermott, ARNTSB MKC73DCQ38Accident · No injuriesClosedCessna 188 · North Fowler, KS
Back to Cessna 188