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 ('2075902')
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 ('2075902')
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 NYC06FA015Accident · 1 fatalField investigationFinal reportCessna 411 · East Hampton, NYThe pilot's failure to maintain airspeed, while maneuvering with the left engine inoperative. Contributing to the accident were the failure of the left engine, and the pilot's lack of multiengine certification.NTSB LAX05FA041Accident · 2 fatalField investigationFinal reportCessna 411 · Corona, CAA loss of engine(s) power for undetermined reasons. Also causal was the pilot's failure to maintain the airplane's minimum controllable airspeed (Vmc) during the initial climb following a loss of power in one engine, which resulted in a loss of aircraft…NTSB LAX03FA147Accident · 1 fatalField investigationFinal reportCessna 411 · Corona, CAThe failure of the pilot to properly configure the airplane for a one engine inoperative condition (including his failure to feather the propeller of the affected engine, retract the landing gear, and maintain minimum single engine speed). Factors related to…NTSB IAD03WA027Accident · No injuriesForeign investigationCessna 411 · Ciudad del Este, ParaguayNTSB CHI02LA117Accident · Serious injuriesLimited investigationFinal reportCessna 411 · Lee's Summit, MOThe pilot failed to maintain control of the airplane during the inital takeoff climb. Factors associated with the accident were the pilot's inadequate preflight of the airplane, the separation of the emergency exit, and the pilot's lack of a multi-engine…NTSB SEA00LA172Accident · Serious injuriesLimited investigationFinal reportCessna 411 · Boise, IDAircraft control was not maintained during approach for landing.NTSB CHI99LA239Accident · No injuriesLimited investigationFinal reportCessna 411 · Troy, MIEngine explosion/fire during start for undetermined reason.NTSB MIA97LA253Accident · No injuriesLimited investigationFinal reportCessna 411 · Williston, FLthe pilot-in-command's excessive taxi speed.NTSB ATL96LA092Accident · No injuriesLimited investigationFinal reportCessna 411 · Rome, GAthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power in both engines, due to an inadequate supply of fuel.NTSB SEA92LA170Accident · No injuriesLimited investigationFinal reportCessna 411 · Lehi, UTThe failure by the pilot to maintain airspeed above VMC, resulting in loss of control in flight, and his failure to lower the flaps and landing gear for the forced landing. A factor relating to the accident was the pilot's decision to perform fuel system…NTSB MIA91FA172Accident · Serious injuriesField investigationFinal reportCessna 411 · North Ft. Myers, FLThe pilot in commands failure to follow emergency procedures and his failure to maintain airspeed following loss of power in one engine resulting in an inadvertent stall and the inflight loss of control with subsequent inflight collision with an object and…NTSB LAX90FA311Accident · 1 fatalField investigationFinal reportCessna 411 · Fallon, NVFailure of the pilot to perform emergency procedures for loss of engine power (including his failure to feather the propeller of the affected engine). Factors related to the accident were: inadequate maintenance, contamination in the fuel system, and overheat…NTSB MIA88FA094Accident · 1 fatalField investigationFinal reportCessna 411 · Venice, FLWitnesses stated that the acft was climbing & just after takeoff, the left wing dropped, the acft then leveled off, climbed aprx 75 more feet. The acft then abruptly turned hard left & went straight in, striking a wall surrounding a swimming pool, burst into…NTSB LAX88FA094Accident · 2 fatalField investigationFinal reportCessna 411 · Temple City, CAPilot of N63CA improper visual look-out. Contributing to this accident was the controller's failure to observe the faster moving airplane approaching the single engine Cessna from the rear.NTSB MIA87LA263Accident · No injuriesLimited investigationFinal reportCessna 411 · No.Atlantic Oc (Atlantic Ocean)The acft was ditched 35 miles southeast of cat island on a flt from georgetown to freeport, Bahamas for unknown reason(s). The acft has not been recovered. Attempts to contact the pilot & registered owner were to no avail.NTSB MIA86LA176Accident · No injuriesLimited investigationFinal reportCessna 411 · Tallahassee, FLThe plt observed a fuel spill on the ground as a result of refueling overflow. He attempted to start the engines & an explosion & fire resulted.NTSB CHI86LA118Accident · No injuriesLimited investigationFinal reportCessna 411 · Bloomington, INThe plt rprtd that while while on final apch to rwy 35, the acft encountered 'extreme wind-shift' & was blown about 550' rgt of course with a 30 kt loss of airspeed (fm 130 to 100 KTS). He stated the acft lost about 300', then was blown back on course with an…NTSB ATL85LA120Accident · No injuriesLimited investigationFinal reportCessna 411 · Mobile, ALThe acft experienced a ttl electrical failure for unknown reasons. The plt descended and flew below low ceilings until and arpt was found. Attempts to lower the landing gear with the emerg hand crank failed. Low on fuel, he landed with gear up. The plt…NTSB LAX84LA490Accident · No injuriesLimited investigationFinal reportCessna 411 · Dolan Springs, AZAfter lndg, the plt was taxiing back up the rwy to a parking area when the nose wheel 'fell into' a sand filled depression in the surface, collapsing the nose gear. County maintenance personnel had graded the rwy surface after heavy rains but no compaction…NTSB MIA83FA226Accident · Serious injuriesField investigationFinal reportCessna C-114A · Ft. Lauderdale, FLThe acft crashed while maneuvering at low airspeed and altitude right after takeoff. The plt said the left engine started losing power intermittently at 90 KTS. The plt had rotated the acft and tried to continue the takeoff. He was cleared to land on any rwy…NTSB LAX83IA345Incident · No injuriesIncident investigationFinal reportCessna 411 · Huntington Bch., CAPilot inadvertantly landed with gear up due to the distraction of making a short field landing.NTSB ATL83FA033Accident · No injuriesField investigationFinal reportCessna 411A · Plymouth, NCThe pilot attempted a takeoff on a wet turf runway and lost control of the aircraft. The aircraft left the runway and collided with trees. Sometime later the aircraft caught fire. The pilot did not cut the switches off. The origin or destination of the flight…NTSB CHI82FA127Accident · 5 fatalField investigationFinal reportCessna 411 · Middlefield, OHThe purpose of the flt was to prepare for a FAA part 135 air taxi check ride which was scheduled later that week. The acft was observed during the approach with one eng shut down. During the turn to final the acft crashed 1/2 mi from rwy 28.NTSB MIA82DKJ02Accident · No injuriesClosedCessna 411 · Panama City, FLNTSB LAX81FVW19Accident · No injuriesClosedCessna 411 · Henderson, NVNTSB ATL81FA093Accident · 1 fatalClosedCessna 411 · Columbus, GANTSB MIA80FA091Accident · 2 fatalClosedCessna 411A · Cape Coral, FLNTSB MIA80FA082Accident · Serious injuriesClosedCessna 411 · Pompano Beach, FLNTSB NYC80FA040Accident · 4 fatalClosedCessna 411 · Vineland, NJNTSB LAX80FUG06Accident · No injuriesClosedCessna 411 · Chino, CANTSB MIA80FA007Accident · No injuriesClosedCessna 411 · Missing AircraftNTSB MIA79FA036Accident · 3 fatalClosedCessna 411 · Jacksonville, FLNTSB FTW78DRA32Accident · No injuriesClosedCessna 411 · Tomball, TXNTSB OAK78FA030Accident · Serious injuriesClosedCessna 411 · Fresno, CANTSB MIA78FLD37Accident · No injuriesClosedCessna 411 · Kissimmee, FLNTSB OAK78FA020Accident · 4 fatalClosedCessna 411 · Chilcoot, CANTSB MIA77PLD83Accident · No injuriesClosedCessna 411 · New Prt Richey, FLNTSB ANC77DA079Accident · 7 fatalClosedCessna 411 · Yakutat, AKNTSB OAK77FVA27Accident · No injuriesClosedCessna 411 · Fresno, CANTSB LAX77DVA19Accident · No injuriesClosedCessna 411 · Porterville, CANTSB MIA77FA026Accident · 2 fatalClosedCessna 411 · Ft Myers, FLNTSB DEN77DQD07Accident · No injuriesClosedCessna 411 · Artesia, NMNTSB CHI77FA020Accident · 2 fatalClosedCessna 411 · Mccomb Twp, MINTSB LAX76FUG46Accident · No injuriesClosedCessna 411 · Thermal, CANTSB LAX76IL049Incident · No injuriesClosedCessna 411 · Riverside, CANTSB OAK76FVW09Accident · No injuriesClosedCessna 411A · Las Vegas, NVNTSB DEN76FTE36Accident · No injuriesClosedCessna 411 · Colorado Spgs, CONTSB NYC76FGM08Accident · No injuriesClosedCessna 411 · New Castle, PANTSB LAX76AL001Accident · 1 fatalClosedCessna 411 · Show Low, AZNTSB IAD75FLT12Accident · Serious injuriesClosedCessna 411 · Memphis, TN
Back to Cessna 411