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 ('8380206')
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 ('8380206')
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 LAX08LA193Accident · 1 fatalLimited investigationFinal reportSnow S2C · Glenn's Ferry, IDFailure of the pilot to maintain an adequate airspeed resulting in an aerodynamic stall/spin while maneuvering.NTSB FTW04LA157Accident · No injuriesLimited investigationFinal reportSnow S2C · La Feria, TXThe pilot's failure to maintain clearance from the obstacle while maneuvering to perform an aerial application. A contributing factor was the high vegetation.NTSB SEA99LA079Accident · No injuriesLimited investigationFinal reportSnow S2C · Paul, IDThe pilot's inaccurate weight and balance calculations, and his delay in jettisoning the load which resulted in his failure to clear rising terrain. Contributing to the accident was the high density altitude, and the pilot's intentional operation with known…NTSB FTW98LA407Accident · No injuriesLimited investigationFinal reportSnow S2C · Bovina, TXThe pilot's failure to maintain directional control during the landing roll.NTSB FTW97LA186Accident · No injuriesLimited investigationFinal reportSnow S2C · Hondo, TXThe pilot's failure to maintain directional control while landing.NTSB SEA96LA020Accident · No injuriesLimited investigationFinal reportSnow S2C · Dufer, ORA loss of engine power due to a cracked cylinder head. A factor was the evasive maneuver to avoid a ditch.NTSB CHI94LA286Accident · No injuriesLimited investigationFinal reportSnow S2C · Leslie, MOthe separation of the cylinder and subsequent oil leak. A factor to the accident was the pilot's restricted visual outlook.NTSB FTW92LA103Accident · No injuriesLimited investigationFinal reportSnow S2C · Roby, TXThe pilot's inadvertent stall of the airplane while maneuvering and subsequent loss of control.NTSB SEA83LA136Accident · No injuriesLimited investigationFinal reportSnow S2C · Hepner, ORThe acft slid sideways on a sloping field during a forced landing and damaged a wing. The pilot said he had sprayed two fields and was enroute to spray another when a complete loss of power occurred. The pilot stated that he found no usablefuel in either fuel…NTSB CHI78FEP45Accident · Minor injuriesClosedSnow S2C · Bancroft, WINTSB CHI76FEP37Accident · No injuriesClosedSnow 600S2C · Plainfield, WINTSB FTW76DRG04Accident · Minor injuriesClosedSnow S2C · Los Fresnos, TXNTSB IAD75FLJ28Accident · No injuriesClosedSnow S2C · Wrightsboro, NCNTSB LAX75DUJ08Accident · No injuriesClosedSnow 600S2C · Poston, AZNTSB LAX74DUM38Accident · No injuriesClosedSnow 600S2C · Calipatria, CANTSB FTW74DRG88Accident · Serious injuriesClosedSnow 600S2C · Brownsville, TXNTSB OAK74AVA31Accident · No injuriesClosedSnow S2C · Tulare, CANTSB NYC74FNC01Accident · 1 fatalClosedSnow 600S2C · Presque Isle, MENTSB FTW73FRG95Accident · No injuriesClosedSnow S2C · Pearsall, TXNTSB FTW73DRG08Accident · No injuriesClosedSnow 600S2C · Sebastian, TXNTSB OAK72DVA26Accident · No injuriesClosedAero Comdr S2C · Huron, CANTSB MIA71FKQ35Accident · 1 fatalClosedSnow S2C · Tutwiler, MSNTSB FTW71FPG51Accident · Serious injuriesClosedSnow S2C · Dewitt, ARNTSB FTW71FQG21Accident · Minor injuriesClosedSnow 600S2C · Hereford, TXNTSB FTW69F0540Accident · Serious injuriesClosedSnow S2C · Millett, TXNTSB OAK68D0246Accident · No injuriesClosedSnow S2C · Tranquillty, CANTSB OAK68A0009Accident · 1 fatalClosedSnow S2C · Huron, CANTSB MIA67F0215Accident · No injuriesClosedSnow S2C · Independence, MSNTSB LAX66F0054Accident · No injuriesClosedSnow S2C · Brawley, CANTSB FTW66D0127Accident · Minor injuriesClosedSnow S2C · Sickles, OKNTSB UNK65X0916Accident · No injuriesClosedSnow S2C · Chowchilla, CANTSB UNK65X0222Accident · No injuriesClosedSnow S2C600 · Ropesville, TXNTSB UNK64X4004Accident · No injuriesClosedSnow S2C · Huron, CANTSB UNK64X2752Accident · 1 fatalClosedSnow S2C · Dover, NCNTSB UNK64X1978Accident · No injuriesClosedSnow S2C · Bartlesville, OKNTSB UNK64X1871Accident · No injuriesClosedSnow S2C · Portageville, MO
Back to Snow S2C