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 ('2075602')
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 ('2075602')
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 ERA25FA008Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 336 · Savannah, GAOn October 13, 2024, about 2230 eastern daylight time, a Cessna 336, N336LV, was destroyed when it was involved in an accident near Savannah, Georgia. The commercial pilot was fatally injured, and a pilot-rated passenger sustained minor injuries. The flight…NTSB WPR22FA216Accident · 1 fatalClass 3 · FieldFinal reportCessna 336 · Porterville, CAMaintenance personnel’s failure to properly secure the elevator control assembly hardware, which resulted in an in-flight disconnection of the elevator and elevator counterweight and the pilot’s inability to maintain pitch control.NTSB ERA14TA326Accident · Serious injuriesFinal reportCessna 336 · Mobile, ALThe pilot’s inadequate preflight fuel planning during which he did not ensure that there was adequate fuel in the main tanks for the flight, which resulted in a loss of engine power.NTSB MIA04FA135Accident · 4 fatalField investigationFinal reportCessna 336 · Magee, MSThe student pilot/ airplane owner's lack of training in night operations, which resulted in spatial disorientation, a loss of control, an uncontrolled descent, and an impact with trees.NTSB LAX01FA271Accident · Serious injuriesField investigationFinal reportCessna 336 · Palmdale, CAThe pilot's inadequate preflight inspection of the primer controls, resulting in excessive fuel flow, spark plug fouling, and loss of engine power in the aft engine.NTSB CHI99LA002Accident · No injuriesLimited investigationFinal reportCessna C-336 · Sheboygan, WIThe pilot's improper flare and improper recovery from a bounced landing.NTSB LAX92FA283Accident · 5 fatalField investigationFinal reportCessna 336A · Big Bear City, CA1) The pilot inadequately evaluating the weather, and 2) the pilot making the inflight decision to continue flight into adverse weather conditions. Factors in this accident were 1) the inability of the pilot to see the mountainous terrain due to the ambient…NTSB MIA87LA050Accident · No injuriesLimited investigationFinal reportCessna 336 · Vero Beach, FLPlt stated the rear engine failed while in cruise flight and while making an emergency landing he approached the runway too fast. The aircraft touched down approximately two thirds of the way down the runway and when it could not be stopped the aircraft was…NTSB ANC85FA070Accident · No injuriesField investigationFinal reportCessna 336 · Anchorage, AKWitness near the crash site stated that both aircraft engines were stopped prior to the accident. The plt reported that before taking off, the fuel quantity gages indicated there was sufficient fuel for the flight, the plt did not preflightthe aircraft.…NTSB NYC84LA116Accident · No injuriesLimited investigationFinal reportCessna 336 · Hogansburg, NYThe acft nosed down in a soggy muddy field during a forced landing. The plt reported a power loss on the rear eng and when attempts to restart were unsuccessful made the forced landing into a soggy muddy field.NTSB ANC83LA140Accident · No injuriesLimited investigationFinal reportCessna 336 · Kenai, AKAccording to the pilot winds were gusty during landing. Upon landing the right wing collided with some trees and pulled the acft to the right into the trees. The acft turned on its back just prior to stopping.NTSB MIA83LA060Accident · No injuriesLimited investigationFinal reportCessna 336 · Key Largo, FLThe acft ditched in shallow water 1/2 mi south of Key Largo, FL while on a flight from zephyrhills, FL to marathon FL. On 1/13 a flt plan was filed for the acft for a flt from kingston jamaica to tampa FL. It departed kinston at 0810 with ETA tampa at 1610.…NTSB MIA80FKA03Accident · No injuriesClosedCessna 336 · Mona Island, PRNTSB MIA79FA115Accident · 2 fatalClosedCessna 336 · San Juan, PRNTSB MIA78FA104Accident · 4 fatalClosedCessna 336 · Lakeland, FLNTSB MKC76AK046Accident · 4 fatalClosedCessna 336 · Mcgregor, IANTSB IAD76FGM07Accident · Minor injuriesClosedCessna 150G · New Cumberland, WVNTSB MKC75FTG21Accident · No injuriesClosedCessna 336 · Hannaford, NDNTSB MKC74DCD01Accident · No injuriesClosedCessna 336 · Bellevue, IANTSB DEN73FTE91Accident · No injuriesClosedCessna 336 · Salida, CONTSB CHI73DEA29Accident · No injuriesClosedCessna 336 · Greenwood, INNTSB MIA73RKT17Accident · No injuriesClosedCessna 336 · Nassau, Burkina FasoNTSB MIA73FKG40Accident · Serious injuriesClosedCessna 336 · Augusta, GANTSB MIA72DKT61Accident · No injuriesClosedCessna 336 · Indiantown, FLNTSB CAN71AW907Accident · No injuriesClosedCessna 336 · Valleyview, CanadaNTSB CHI70AC074Accident · 2 fatalClosedCessna 336 · Chicago, ILNTSB LAX70A0023Accident · 5 fatalClosedCessna 336 · Cabazon, CANTSB SEA70D0022Accident · No injuriesClosedCessna 336 · Coolin, IDNTSB MIA70D0031Accident · Minor injuriesClosedCessna 336 · Frsh Crek, Burkina FasoNTSB DIA70F0035Accident · No injuriesClosedCessna 336 · Taplin, WVNTSB UNK68X0152Accident · No injuriesClosedCessna 336 · Finlay Fks, CanadaNTSB MIA69R0001Accident · 1 fatalClosedCessna 336 · Wms Isle, Burkina FasoNTSB OAK68A0004Accident · 1 fatalClosedCessna 336 · Bishop, CANTSB NYC67D0687Accident · No injuriesClosedCessna 336 · White Plains, NYNTSB OAK66F0298Accident · Serious injuriesClosedCessna 336 · Concord, CANTSB LAX65F0001Accident · No injuriesClosedCessna 336 · Yerington, NVNTSB UNK65X1355Accident · 4 fatalClosedCessna 336 · Mexico City, MexicoNTSB UNK65X1354Accident · 4 fatalClosedCessna 210 · Mexico City, Mexico
Back to Cessna 336