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 ('2076010')
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 ('2076010')
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 CEN23LA267Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Rockport, TXThe failure of the left engine starter adapter gear, which resulted in catastrophic damage to other engine components, and the subsequent loss of engine power.NTSB ERA19FA283Accident · 3 fatalClass 3 · FieldFinal reportCessna 421 · Deland, FLThe pilot’s failure to maintain control of the airplane, which resulted in a collision with terrain. Contributing was the pilot’s lack of training and experience in the accident airplane make and model.NTSB CEN14LA256Accident · No injuriesLimited investigationFinal reportCessna 421 · Horseshoe Bay, TXThe failure of the drive mechanism for the gearbox motor, which resulted in the gear not extending for the landing.NTSB CHI07LA154Accident · Serious injuriesLimited investigationFinal reportCessna 421 · Chesterfield, MOMaintenance personnel failed to comply with an Airworthiness Directive which resulted in the total failure of the starter adapter gear teeth and the crankshaft gear teeth and the pilot failed to follow the published emergency procedures. Contributing to the…NTSB SEA07LA055Accident · No injuriesLimited investigationFinal reportCessna 421 · Pocatello, IDThe separation of the bolt that attaches the elevator trim tab actuator rod to the elevator trim tab horn, resulting in violent flutter of the elevator, and eventually to the separation of the inboard half of the right elevator.NTSB DEN05FA038Accident · 3 fatalField investigationFinal reportCessna 421 · Englewood, COloss of engine power due to fuel starvation, and the instructor's failure to maintain aircraft control. Contributing factors were a partially blocked fuel line resulting in restricted fuel flow, the instructor's failure to perform critical emergency…NTSB IAD03FA032Accident · 3 fatalField investigationFinal reportCessna 421 · Ferguson, KYThe pilot's failure to follow the instrument approach procedure, which resulted in an early descent into trees and terrain. Factors included the low ceiling and the night lighting conditions.NTSB DEN03FA025Accident · 2 fatalField investigationFinal reportCessna 421 · Akron, COThe fractured connecting rods and the pilot not maintaining aircraft control following the engine failure. Factors contributing to the accident were the low altitude, the pilot not maintaining minimum controllable airspeed following the engine failure, the…NTSB ATL01FA036Accident · 5 fatalField investigationFinal reportCessna 421 · Munford, ALThe pilot continued visual flight into instrument weather conditions that resulted in the inflight collision with a river bank. Factors were reduced visibility and dark night.NTSB CHI98FA187Accident · 1 fatalField investigationFinal reportCessna 421 · Little Falls, MNthe pilot's continued operation with a known deficiency in equipment.NTSB FTW97FA130Accident · 1 fatalField investigationFinal reportCessna 421 · League City, TXThe pilot's failure to refuel the airplane which resulted in the loss of power to the right engine due to fuel exhaustion, and the pilot's failure to maintain airspeed during the single engine landing approach which resulted in a stall/spin.NTSB CHI96FA146Accident · 3 fatalField investigationFinal reportCessna 421 · Bernard, IAthe pilot's operation of the airplane with known deficiencies, subsequent loss of oil from the left engine, and the pilot's failure to maintain minimum controllable airspeed (VMC), while diverting to an alternate airport. Factors relating to the accident…NTSB SEA95LA194Accident · No injuriesLimited investigationFinal reportCessna 421 · Creswell, ORthe company mechanic's failure to properly fabricate a fuel line.NTSB MIA94LA019Accident · No injuriesLimited investigationFinal reportCessna 421 · Miami, FLFailure of the pilot-in-command to obtain the proper assistance after being notified of a fuel leak from the left wing fuel tanks after refueling.NTSB DEN91LA066Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Englewood, COPower loss on both engines as a result of exhaust system failure.NTSB LAX91LA142Accident · No injuriesLimited investigationFinal reportCessna 421 · El Monte, CAThe pilot retracting the landing gear during the landing roll.NTSB FTW89LA135Accident · Serious injuriesLimited investigationFinal reportCessna 421 · Okmulgee, OKFailure of the nose gear extension assembly and the pilot's improper precautionary landing procedures that included securing the engines prior to a point where a safe landing was assured.NTSB LAX89LA217Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Picacho, AZFailure of the number three exhaust valve on the left engine. A major factor was the high density altitude where the airplane would not operate on single engine.NTSB FTW89FA074Accident · 1 fatalField investigationFinal reportCessna 421 · Brownsville, TXThe pilot's improper emergency procedure after lossing power in the right engine, and his failure to maintain minimum control speed (VMC), which resulted in a loss of aircraft control. Factors related to the accident were: fuel starvation of the right engine,…NTSB NYC88FA181Accident · 1 fatalField investigationFinal reportCessna 421 · Taunton, MABfr rchg his destn, the plt adzd apch ctl that his rgt eng was 'blowing some smoke' & losing oil pressure. Vectors were provided for a visual apch, but there were low clouds in the area & vis was restricted due to haze. After reaching the vcnty of the arpt,…NTSB MIA87FA239Accident · 1 fatalField investigationFinal reportCessna 421 · Coral Springs, FLThe acft had been abandoned in the Bahamas for aprx 7 months. A plt, with no known flt time in a Cessna 421, flew it to ft lauderdale. Except to avoid clds, he made the flt at a low alt & airspeed. When asked why, he said he was trying to save the engs. The…NTSB FTW86FA133Accident · 4 fatalField investigationFinal reportCessna 421 · Addison, TXWitnesses reported a normal takeoff and climb was made to an alt of aprx 400 ft AGL at which time eng pwr ceased/ decreased. The rt wing then dropped, the nose and lt wing rose and the acft entered a near vertical descent to ground impact. Post accident exam…NTSB FTW85LA218Accident · No injuriesLimited investigationFinal reportCessna 421 · Mckinney, TXAfter landing while taxiing on the rwy, the acft's nose wheel started bogging down in soft asphalt on the rwy. The soft asphalt was pushed along in front of the wheel until it caused enough resistance to overstress the nose gear causing it to collapse. The…NTSB CHI84FA303Accident · 3 fatalField investigationFinal reportCessna 421 · Birchwood, WIDuring flt, the plt transmitted to ARTCC 'we've got a problem, we're losing altitude.' The controller provided a vector to the nearest arpt, but shortly after that, the plt stated that he would not be able to reach the arpt. The plt did not inform ARTCC of…NTSB LAX83LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Glendale, AZThe pilot reported performing a normal preflight and run-up. No water was observed in the fuel during preflight. Full power was applied and the acft accelerated to 55 KTS. As the acft rotated and climb attitude established the engine sputtered. The pilot…NTSB ATL83LA120Accident · No injuriesLimited investigationFinal reportCessna 421 · Dayton, TNThe Cessna 421 collided with trees during the landing approach while on a corporate flight. The weather was IMC at the accident site and the acft was on an IFR flight plan. The acft was substantially damaged but the pilot was not injured. The acft contacted…NTSB CHI82FA209Accident · No injuriesField investigationFinal reportCessna 421 · Racine, WIThe plt stated he experienced moderate to severe turbulence enroute. A coupled ILS approach was flown without problems, but the plt stated he had to work hard. The flt broke out at about 1,000 ft MSL & at this time he acquired visual contact with the rwy. He…NTSB CHI82FA091Accident · 1 fatalField investigationFinal reportCessna 421 · Richmond, INDuring a VOR approach to runway 05 when 3 miles away from the airport at minimums ground contact was not made. The pilot stated that she elected to perform a missed approach but before power was applied the copilot raised the flaps. She further stated that…NTSB CHI81FEV31Accident · No injuriesClosedCessna 421 · Springfield, ILNTSB LAX81FUA13Accident · Minor injuriesClosedCessna 421 · Long Beach, CANTSB ATL81FKG20Accident · No injuriesClosedCessna 421 · Statesboro, GANTSB MKC81FA035Accident · No injuriesClosedCessna 421 · Spencer, IANTSB MIA81FA042Accident · 6 fatalClosedCessna 421 · Ft Lauderdale, FLNTSB MIA80DLE06Accident · No injuriesClosedCessna 421 · Orlando, FLNTSB LAX80FUG58Accident · No injuriesClosedCessna 421 · Palm Springs, CANTSB LAX80FUQ22Accident · No injuriesClosedCessna 421A · Lancaster, CANTSB SEA80FYK13Accident · Minor injuriesClosedCessna 421 · Redmond, ORNTSB IAD79FID24Accident · Serious injuriesClosedCessna 421 · Norfolk, VANTSB IAD79FA046Accident · No injuriesClosedCessna 421 · Sevierville, TNNTSB FTW79FRG25Accident · No injuriesClosedCessna 421 · Lakeway, TXNTSB UNK79X0106Accident · No injuriesClosedCessna 421 · Bezier, FranceNTSB MKC77FCD26Accident · No injuriesClosedCessna 421 · Cedar Rapids, IANTSB FTW76FPD27Accident · Minor injuriesClosedCessna 421 · Iowa Park, TXNTSB NYC76AN036Accident · No injuriesClosedDassault Falcon · Warwick, RINTSB NYC75AN037Accident · Minor injuriesClosedCessna 421 · Westfield, MANTSB MKC74FCG43Accident · No injuriesClosedCessna 421 · Springfield, MONTSB MKC74AK056Accident · 5 fatalClosedCessna 421 · Bunker, MONTSB NYC74FHJ20Accident · No injuriesClosedCessna 421 · Farmingdale, NYNTSB FTW74FPM18Accident · Minor injuriesClosedCessna 411 · Tulsa, OKNTSB CHI74AC042Accident · 5 fatalClosedCessna 421 · Plymouth, IN
Back to Cessna 421