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 ('2076020')
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 ('2076020')
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 WPR26FA309Accident · 8 fatalClass 3 · FieldPreliminary reportCessna 441 · Cape Newenham, AKOn August 20, 2026, at about 1145 Alaska daylight time, a Cessna 441, N128EZ, was destroyed when it was involved in an accident near Cape Newenham, Alaska. The two pilots and six passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB CEN26LA105Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 441 · Pflugerville, TXThe pilot’s failure to maintain airplane control during a rejected takeoff due to a flat nose wheel tire which resulted in a runway excursion and impact with terrain. Contributing to the accident was pilot fatigue which delayed the rejected takeoff.NTSB ERA25FA246Accident · 6 fatalClass 3 · FieldPreliminary reportCessna 441 · Warren, OHOn June 29, 2025, about 0654 eastern daylight time, a Cessna 441, N441LS, was destroyed when it was involved in an accident near Warren, Ohio. The airline transport pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code…NTSB WPR23LA072Accident · No injuriesClass 4 · LimitedFinal reportCessna 441 · Liberal, KSThe pilot’s inadequate preflight inspection, failure to set the parking brake, and his decision to exit the airplane with engines running to remove a wheel chock, resulting in the airplane’s unintended movement and subsequent collision with a hangar.NTSB ERA21LA124Accident · 2 fatalClass 3 · LimitedFinal reportCessna 441 · Belvidere, TNThe pilot’s failure to follow the published instrument approach procedure by prematurely descending the airplane below the final approach fix altitude to fly under the low ceiling conditions, which resulted in controlled flight into terrain.NTSB CEN19FA030Accident · 3 fatalClass 2 · FieldFinal reportCessna 441 · Harmon, NDThe pilot's failure to maintain control of the airplane in dark night conditions that resulted in an in-flight positive overload failure of the wings and the subsequent in-flight breakup of the airplane.NTSB CEN18FA107Accident · 3 fatalField investigationFinal reportCessna 441 · Rossville, INAn in-flight loss of control for reasons that could not be determined based on the available evidence.NTSB CEN16LA098Accident · No injuriesLimited investigationFinal reportCessna 441 · Fargo, NDThe pilot’s failure to cycle the surface deice boots during the instrument approach in icing conditions, which led to ice accumulation on the leading edges of the wings and empennage, and resulted in an aerodynamic stall and subsequent hard landing.NTSB ERA16FA035Accident · 2 fatalField investigationFinal reportCessna 441 · Climax, GAThe pilot’s loss of airplane control due to spatial disorientation. Also causal to the accident was the pilot’s impairment by the combined effects of multiple medications and drugs.NTSB CEN15FA136Accident · 1 fatalField investigationFinal reportCessna 441 · Argyle, TXThe pilot's failure to maintain adequate airspeed during the instrument approach in night instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin at a low altitude.NTSB CEN12CA215Accident · No injuriesData collectionFinal reportCessna 441 · Battle Creek, MIThe maintenance technician did not remove the tow bar prior to the flight.NTSB ERA12FA120Accident · 1 fatalField investigationFinal reportCessna 441 · Nashville, PAThe pilot's failure to maintain minimum control airspeed after a loss of power to the right engine, which resulted in an uncontrollable roll into an inadvertent stall/spin. Contributing to the accident was the failure of the airplane's right engine for…NTSB CEN09LA415Accident · No injuriesLimited investigationFinal reportCessna 441 · Albuquerque, NMA malfunction of the landing gear selector switch and a loose fitting on the emergency extension system which rendered the landing gear system inoperable.NTSB SEA08FA161Accident · 1 fatalField investigationFinal reportCessna 441 · Sunriver, ORThe pilot's misjudged landing flare and improper recovery from a bounced landing, and the pilot's failure to maintain directional control during the go-around after one of the airplane's propellers struck the runway.NTSB ANC05LA130Accident · No injuriesLimited investigationFinal reportCessna 441 · Anchorage, AKThe pilot's failure to lower the airplane's landing gear during landing, which resulted in an inadvertent wheels up landing.NTSB LAX05CA059Accident · No injuriesData collectionFinal reportCessna 441 · Thermal, CAthe pilot's misjudged speed and distance, which resulted in a failure to attain the proper touchdown point and a subsequent overrun of the runway. A factor in the accident was limited braking effectiveness resulting from the wet runway condition.NTSB MIA04FA037Accident · 1 fatalField investigationFinal reportCessna 441 · Greenacres City, FLThe pilot's failure to maintain aircraft control, which resulted in an inadvertent stall/spin and subsequent uncontrolled descent into a canal. A factor was the pilot's impairment by the drug chlorpheniramine.NTSB ATL04FA049Accident · 2 fatalField investigationFinal reportCessna 441 · Vestavia Hills, ALThe pilot's failure to maintain adequate airspeed during climb in icing conditions, which resulted in an inadvertent stall / spin of the airplane and subsequent uncontrolled descent and collision with terrain. A factor was the accumulation of airframe ice.NTSB SEA02LA095Accident · No injuriesLimited investigationFinal reportCessna 441 · Medford, ORThe overstress failure, for undetermined reasons, of the right main landing gear pivot pin roll pin, leading to the misalignment of the gear trunnion and the collapse of the right main gear during the landing roll.NTSB CHI02FA074Accident · 2 fatalField investigationFinal reportCessna 441 · Winfield, KSThe pilot's spatial disorientation resulting in a loss of control and collision with the ground. Additional factors included the pilot operating the airplane with known deficiencies and the instrument flight conditions.NTSB ATL02FA031Accident · 5 fatalField investigationFinal reportCessna 441 · Rio Grande, PRThe pilot continued visual flight flight into instrument flight conditions resulting in an in-flight collision with terrain. Low clouds were a factor.NTSB DEN01LA052Accident · No injuriesLimited investigationFinal reportCessna 441 · Englewood, COthe pilot's failure to verify that the landing gear was down and locked before landing, which resulted in a wheels-up landing.NTSB MIA97LA056Accident · Minor injuriesLimited investigationFinal reportCessna 441 · Lakeland, FLFailure of the electronic engine control, which caused an overtorque condition in the right engine that made directional control of the airplane not possible by the pilot when the power to the left engine was retarded to idle during the takeoff roll.NTSB MIA96WA124Accident · No injuriesForeign investigationCessna C441 · Walkers Cay, BahamasNTSB NYC95WA109Accident · No injuriesForeign investigationCessna 441 · Bayrouth, GermanyNTSB CHI95MA044Accident · 2 fatalClass 1 · MajorFinal reportCessna 441 · Bridgeton, MOThe Cessna 441 pilot's mistaken belief that his assigned departure runway was runway 30R, which resulted in his undetected entrance onto runway 30R, which was being used by the MD-82 for its departure. Contributing to the accident was the lack of Automatic…NTSB ATL92LA156Accident · Serious injuriesLimited investigationFinal reportCessna 441 · Gainesville, GAThe poor inflight decision by the pilot in command in that after a partial loss of power, he shut down the wrong engine, did not follow the emergency checklist, did not raise the flaps, and did not retract the landing gear. A factor in the accident was the…NTSB LAX87FA119Accident · 2 fatalField investigationFinal reportCessna 441 · Flagstaff, AZThe acft was on an emerg med svc (ems/med-evac) flt with a plt & flt nurse aboard to transport a maternity patient fm Flagstaff to phoenix. Drg a ngt arrival, the plt bgn a vor-a apch in IMC, then he rprtd a problem with his avionics & elected to make a…NTSB NYC87LA041Accident · No injuriesLimited investigationFinal reportCessna 441 · Erie, PAReason for the Cessna to veer in a semi-circle and collide with another aircraft is undetermined. Examination of the start lock assemblies could not be completed due to the extensive impact and fire damage. The acft was being prepared for a flt. During a…NTSB CHI87FA009Accident · 1 fatalField investigationFinal reportCessna 441 · West Chicago, ILThe plt (a part time employee of the owner) was ferrying the acft for maintenance. Witnesses, who saw the plt bfr take- off, noted that his speech was slurred & that he seemed angry because a tug would not start. One witness characterized him as being 'very…NTSB CHI86FA172Accident · 3 fatalField investigationFinal reportCessna 441 · Norton Shores, MIN6857E was transporting executives from holland, MI, to muskegon. The pilot was executing an asr approach to runway 06. The mda is 537 ft AGL. Co-pilot called out 1200 feet then below 1000 feet, pilot continued approach. Aircraft struck trees two miles from…NTSB ATL86FMG03Accident · Minor injuriesFinal reportCessna 441 · West Columbia, SCDuring final approach the plt noticed acft flying 'unusual' and elected go-around. During power-up, the acft lost power and a forced landing was made on a residential street near the arpt. The plt stated that he had inadvertenly placed the fuel selector in…NTSB CHI86MA025Accident · 5 fatalMajor investigationFinal reportCessna 441 · Derry, PADrg arrival, the plt was advised the destn wx was: estd 500' overcast, vis 1 mi with fog, arpt blo mins. The plt electedto make an NDB rwy 23 apch, but said he would divert if a missed apch was made. He was provided radar vectors & was clrdfor the apch. At…NTSB FTW85FA086Accident · 1 fatalField investigationFinal reportCessna 441 · Marble Falls, TXThe acft crashed aprx 1.5 miles south of the departure end of rwy 17 during an attempted rwy 17 NDB apch. The acft was cleared for the apch at 2012 CST and the plt canceled IFR reporting the arpt in sight at 2014. A witness located aprx 1 mile south of the…NTSB FTW85LA042Accident · Minor injuriesLimited investigationFinal reportCessna 441 · Grand Chenier, LAThe pilot told the cameron parrish sheriff that he was attempting to land the aircraft at a small agricultural landing strip after one of the two engines quit due to fuel starvation. The pilot stated that there was nothing wrong with the aircraft except that…NTSB MKC83IA109Incident · No injuriesIncident investigationFinal reportCessna 441 · Arkansas City, KSThe pilot experienced elevator control problems and made an emergency landing on an abandoned airstrip. The elevator trim cable had come off of the electric trim servo drum and was tangled in the auto pilot. An unrelated fire destroyed the aircraft. Post fire…NTSB DEN80FA031Accident · 2 fatalClosedCessna 441 · Butte, MTNTSB IAD80AA018Accident · 2 fatalClosedCessna 441 · Atlantic Ocean (Atlantic Ocean)NTSB LAX80FUD03Accident · No injuriesClosedCessna 441 · Los Angeles, CANTSB MIA78FA013Accident · 7 fatalClosedCessna 441 · Greensboro, AL
Back to Cessna 441