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 ('2076604')
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 ('2076604')
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 WPR26MA063Accident · 7 fatalClass 2 · MajorPreliminary reportCessna 550 · Statesville, NCOn December 18, 2025, at 1015 eastern standard time, a Cessna Citation 550, N257BW, was destroyed when it was involved in an accident near Statesville, North Carolina. The pilot and 6 passengers were fatally injured. The airplane was operated as a Title 14…NTSB CEN24FA320Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 550 · Odessa, TXOn August 20, 2024, about 0700 central daylight time, a Cessna 550 airplane, N689VP, was destroyed when it was involved in an accident near Odessa, Texas. The pilot and passenger were fatally injured. A person on the ground was seriously injured. The airplane…NTSB GAA24WA181Incident · No injuriesClass 3 · ForeignCessna 550 · Basseterre, St. Kitts & NevisNTSB WPR23FA257Accident · 6 fatalClass 3 · FieldFinal reportCessna 550 · Murrieta, CAThe flight crew’s decision to descend below the decision altitude of an instrument approach without having the appropriate runway visual reference(s) distinctively identified and with the visibility below the minimum that was prescribed for the approach,…NTSB CEN23LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · Oklahoma City, OKThe pilot’s improper landing flare, which resulted in a hard, bounced landing, runway excursion, and subsequent collision with a runway sign. Contributing to the accident was the pilot’s lack of experience in the airplane, the unstabilized approach, and…NTSB CEN22LA434Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · McGregor, TXThe flight crew’s failure to ensure the landing gear was down which resulted in a gear up landing and subsequent runway excursion.NTSB ERA21LA227Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · Charleston, SCThe airplane's impact with a deer during takeoff.NTSB WPR19TA193Accident · Minor injuriesClass 3Final reportCessna 550 · Mesquite, NVThe pilot's operation of the airplane while intoxicated, which resulted in a loss of airplane control on landing.NTSB ERA19IA178Incident · No injuriesClass 3 · IncidentFinal reportCessna 550 · Savannah, GAThe lineman's inadvertent introduction of diesel exhaust fluid (DEF) to the fuel truck fuel system icing inhibitor reservoir, which resulted in fuel contamination and a total loss of engine power. Contributing to the accident was the fixed-base operator's…NTSB CEN19LA039Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Fargo, NDThe pilot's failure to lower the flaps during the approach and maintain sufficient airspeed while flying in instrument meteorological and icing conditions and the accumulation of ice on the wings’ leading edges, which resulted in the exceedance of the…NTSB GAA17CA207Accident · No injuriesData collectionFinal reportCessna 550 · Salt Lake City, UTAn in-flight collision with a goose during approach.NTSB CEN17LA136Accident · No injuriesLimited investigationFinal reportCessna 550 · Port Aransas, TXAn in-flight collision with multiple birds, which resulted in separation of the right engine's fan rotor and subsequent total loss of power of the right engine.NTSB ERA15LA380Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Sarasota, FLThe pilot’s failure to attain the proper touchdown point and to adequately slow the airplane within the available runway, which resulted in a runway overrun.NTSB CEN13TA113Accident · Minor injuriesFinal reportCessna 550 · Oklahoma City, OKThe flight crew's decision to fly close behind a heavy airplane, which did not ensure there was adequate distance and time in order to avoid a wake turbulence encounter with the preceding heavy airplane’s wake vortex, which resulted in a loss of airplane…NTSB ERA13LA061Accident · No injuriesLimited investigationFinal reportCessna 550 · Greenwood, SCCollision with a deer during the landing roll, which resulted in a compromised fuel tank and a postimpact fire.NTSB ERA11FA001Accident · Minor injuriesField investigationFinal reportCessna 550 · Manteo, NCThe pilot-in-command's failure to maintain proper airspeed and his failure to initiate a go-around, which resulted in the airplane touching down too fast on a short, wet runway and a subsequent runway overrun. Contributing to the accident was the copilot's…NTSB WPR09LA171Accident · No injuriesLimited investigationFinal reportCessna 550 · Salt Lake City, UTThe uncommanded retraction of the right main landing gear hydraulic actuator strut for undetermined reasons.NTSB ERA09LA130Accident · No injuriesLimited investigationFinal reportCessna 550 · Wilmington, NCA loss of engine power due to the crew's inadequate in-flight fuel monitoring.NTSB CHI07MA160Accident · 6 fatalClass 1 · MajorFinal reportCessna 550 · Milwaukee, WIThe National Transportation Safety Board determines that the probable cause of this accident was the pilots’ mismanagement of an abnormal flight control situation through improper actions, including failing to control airspeed and to prioritize control of the…NTSB NYC07FA058Accident · Serious injuriesField investigationFinal reportCessna 550 · Butler, PAThe copilot's failure to maintain the proper airspeed, and failure to obtain the proper touchdown point, and the pilot-in-command's inadequate supervision, which resulted in an overrun. Contributing to the accident was the PIC's failure to activate the speed…NTSB ANC05LA150Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Ft Yukon, AKThe pilot's improper use of anti-icing equipment during cruise flight, which resulted in ice ingestion into both engines (foreign object damage), the complete loss of engine power in both engines, and an emergency descent and landing on tree covered terrain.…NTSB MIA04LA124Accident · No injuriesLimited investigationFinal reportCessna 550 · Venice, FLThe pilot's failure to maintain adequate airspeed which resulted in a stall and undershoot of the runway.NTSB FTW02LA154Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Bethany, OKthe anomalous elevator trim system and the pilot's failure to note its improper setting prior to takeoff.NTSB DCA02WA027Incident · No injuriesForeign investigationCessna Citation C-750 · Zurich, SwitzerlandNTSB MIA00LA063Accident · No injuriesLimited investigationFinal reportCessna 550 · Homestead, FLAn inadvertent in-flight collision with a bird in cruise flight resulting in substantial damage to the airplane.NTSB NYC99IA079Incident · No injuriesIncident investigationFinal reportCessna 550 · State College, PAImproper assembly of the left main landing gear (LMLG) actuator by the airplane manufacturer, which resulted in an incorrect 'locked' indication on the LMLG switch, and the subsequent collapse of the LMLG during taxi.NTSB MIA96FA051Accident · 2 fatalField investigationFinal reportCessna 550 · East Naples, FLThe pilot's disregard for the MDA for a specific segment of the VOR/DME approach which resulted in the inflight collision with a guy wire of an antenna and separation of 8.5 feet of the left wing.NTSB FTW95WA227Accident · No injuriesForeign investigationCessna 550 · Soto Cano, HondurasNTSB MIA95WA120Accident · Minor injuriesForeign investigationCessna 550 · Walkers Cay, BahamasNTSB FTW93TA#06Accident · No injuriesFinal reportCessna CE-550 · Comayagua, HondurasNTSB SEA93GA041Accident · 8 fatalFinal reportCessna 550 · Billings, MTThe pilot-in-command's failure to follow established vortex avoidance procedures, as published in the airman's information manual, to provide his own wake turbulence separation.NTSB FTW93WA026Accident · No injuriesForeign investigationCessna 550 · Comayagua, HondurasNTSB FTW90FA002Accident · 2 fatalField investigationFinal reportCessna 550 · Hurdle Mills, NCImpairment of the pilot-in-command (PIC) due to drugs/medication, chemotherapy and fatigue; failure of the PIC to assure that the IFR (instrument) apch procedure was followed; and his failure to maintain the minimum descent altitude (mda). Inadequate…NTSB FTW83AA104Accident · No injuriesFinal reportCessna 550 · Houston, TXAfter landing on rwy 31L, the aircrew of N100VV requested clearance to turn off to the right at midfield onto rwy 22. The request was approved & the aircrew was instructed to use caution for a cherokee proceeding from the opposite direction. The plt of N100VV…NTSB LAX74OL007Accident · No injuriesClosedCessna 172L · Sonoyta, MexicoNTSB MIA71DKG61Accident · No injuriesClosedCessna 310 · Cornelia, GA
Back to Cessna 550