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 ('2075702')
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 ('2075702')
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 WPR22FA160Accident · 1 fatalClass 3 · FieldFinal reportCessna 337 · Sylmar, CAThe pilot’s loss of airplane control while troubleshooting a landing gear issue, which resulted in an aerodynamic stall/spin at an altitude too low to recover. Contributing to the accident was the pilot’s impairment from alcohol consumption.NTSB GAA15CA158Accident · No injuriesData collectionFinal reportCessna 337 · Blanding, UTThe pilot's selection of a departure runway of inadequate length for the density altitude, resulting in the airplane not gaining sufficient lift, departing the runway, and impacting terrain.NTSB CEN10CA305Accident · No injuriesData collectionFinal reportCessna 337 · Custer, SDA partial loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel mismanagement.NTSB LAX04FA241Accident · 1 fatalField investigationFinal reportCessna 337 · Carson City, NVthe pilot's failure to maintain an adequate airspeed while maneuvering during a go-around that led to an inadvertent stall spin.NTSB DEN99LA145Accident · No injuriesLimited investigationFinal reportCessna 337 · Edgewood, NMBreakage of the safety wire that secured the propeller control cable to the support bracket. Factors were the inability of the pilot to feather the propeller or change propeller rpm, and rough, uneven, and unsuitable terrain on which to make a forced landing.NTSB SEA93LA160Accident · Serious injuriesLimited investigationFinal reportCessna 337 · Jerome, IDThe pilot's improper fuel management procedures which resulted in fuel starvation. Factors include the pilot's lack of familiarity with this type aircraft, and rough/uneven terrain in the landing area.NTSB MIA92FA070Accident · 3 fatalField investigationFinal reportCessna 337 · Moore Haven, FLThe pilot-in-command's in flight loss of control due to spatial disorientation. Contributing to the accident was the pilot-in-command's lack of total experience in night flight, and the lack of natural horizon or surface reference while flying over a sparsely…NTSB SEA91FA071Accident · 1 fatalField investigationFinal reportCessna 337 · Boise, IDThe pilot's failure to remove the aircraft control locks prior to attempting flight. Factors include an inadequate preflight.NTSB ANC90LA128Accident · No injuriesLimited investigationFinal reportCessna 337 · Kustatan River, AKPilot-in-command's failure to assure that the rear engine developed full takeoff power and to attain takeoff airspeed. Contributing factors were the terrain conditions.NTSB NYC90LA147Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Bedford, NYThe failure of the pilot to monitor the fuel gauges and fuel starvation. A factor related to the accident was the failure of maintenance personnel to detect the bent condition of the rear engine tank fuel selector control cable.NTSB DEN90LA106Accident · No injuriesLimited investigationFinal reportCessna 337 · Broomfield, COThe pilot's failure to properly execute a precautionary approach following an engine failure.NTSB NYC89LA098Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Bethel, NYImproper planning/decision by the pilot concerning his fuel management, which resulted in fuel exhaustion due to an inadequate supply of fuel. The false indication from the fuel quantity gage(s), dark night, and trees were considered to be factors.NTSB NYC84FHD02Accident · 1 fatalFinal reportCessna 337 · Coatsville, PAAfter touchdown about 2,000 ft down the 4,600 x 100 ft rwy the acft bounced back into the air. Witnesses observed the acft rt wing drop causing it to veer to the rt toward a line of parked acft. 900 ft from initial touchdown the acft impacted rt wing first in…NTSB LAX81FUJ71Accident · No injuriesClosedCessna 337 · Quartzsite, AZNTSB MIA80FA060Accident · 1 fatalClosedCessna 337 · Atlanta, GANTSB MIA79FLD07Accident · Serious injuriesClosedCessna 337 · Sanford, FLNTSB CHI78FEE37Accident · Minor injuriesClosedCessna 337 · Dupage, ILNTSB MIA78FKA01Accident · Minor injuriesClosedCessna 337 · San Juan, PRNTSB FTW78FRG02Accident · No injuriesClosedCessna 337 · Floresville, TXNTSB MIA77DA078Accident · No injuriesClosedCessna 337 · Barranquilla (Gulf of Mexico)NTSB LAX77DUM17Accident · Minor injuriesClosedCessna 337 · San Diego, CANTSB FTW76ORG71Accident · 2 fatalClosedCessna 337 · Amatlan, MexicoNTSB OAK76DVD35Accident · No injuriesClosedCessna 337 · Sonoma, CANTSB LAX76AL052Accident · 2 fatalClosedCessna 337 · Maricopa, AZNTSB CHI76AC004Accident · 1 fatalClosedCessna 337 · St Johns, MINTSB MIA76OKT02Accident · Minor injuriesClosedCessna 337 · Great Inagua, Burkina FasoNTSB SEA7KDYG46Accident · No injuriesClosedCessna 337 · Mackey Bar, IDNTSB CHI75FEE46Accident · Serious injuriesClosedCessna 337 · Chicago, ILNTSB CHI75AC042Accident · 1 fatalClosedCessna 337B · Griffith, INNTSB LAX75OL004Accident · 4 fatalClosedCessna 337 · Punta Chivato, MexicoNTSB FTW73FPG35Accident · Serious injuriesClosedCessna 337 · Harrison, ARNTSB FTW73DPG25Accident · No injuriesClosedCessna 337B · Lonoke, ARNTSB CHI73FEM11Accident · No injuriesClosedCessna 337 · Grand Rapids, MINTSB OAK72DVD30Accident · No injuriesClosedCessna 337 · Hayward, CANTSB CHI72FEC18Accident · No injuriesClosedCessna 337 · Ann Arbor, MINTSB FTW72DRA15Accident · No injuriesClosedCessna 337 · Sabine Pass, TXNTSB OAK72AP006Accident · 1 fatalClosedCessna 337 · Grass Valley, CANTSB LAX72AL012Accident · 4 fatalClosedCessna 337 · Calexico, CANTSB FTW72FRG07Accident · No injuriesClosedCessna 337 · Corpus Chrsti, TXNTSB LAX71DUJ10Accident · No injuriesClosedCessna 337 · Tucson, AZNTSB DEN71FTE04Accident · No injuriesClosedCessna 337 · Thornton, CONTSB LAX71DUG53Accident · No injuriesClosedCessna 337 · Upland, CANTSB LAX71FUA17Accident · No injuriesClosedCessna 337 · Huntingtn Bch, CANTSB MIA70DMD01Accident · No injuriesClosedCessna 337 · Guanaja, HONTSB NYC69D0390Accident · No injuriesClosedCessna 337 · Ambler, PANTSB CHI70F0196Accident · Serious injuriesClosedCessna 337 · Monmouth, ILNTSB CHI69D0459Accident · No injuriesClosedCessna 337 · Northbrook, ILNTSB MIA69A0035Accident · No injuriesClosedCessna 337 · Chamblee, GANTSB OAK69A0029Accident · Serious injuriesClosedCessna 337 · Visalia, CANTSB OAK69D0076Accident · No injuriesClosedCessna 337 · Petrolia, CA
Back to Cessna 337