NTSB investigations: Snow S2C, TX
11 cases on aircraft the registry lists as Snow S2C. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1964 | 1 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2004 | 1 |
Where
Open the mapLatest cases
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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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 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 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 FTW92LA103Accident · No injuriesLimited investigationFinal reportSnow S2C · Roby, TXThe pilot's inadvertent stall of the airplane while maneuvering and subsequent loss of control.NTSB FTW76DRG04Accident · Minor injuriesClosedSnow S2C · Los Fresnos, TXNTSB FTW74DRG88Accident · Serious injuriesClosedSnow 600S2C · Brownsville, TXNTSB FTW73FRG95Accident · No injuriesClosedSnow S2C · Pearsall, TXNTSB FTW73DRG08Accident · No injuriesClosedSnow 600S2C · Sebastian, TXNTSB FTW71FQG21Accident · Minor injuriesClosedSnow 600S2C · Hereford, TXNTSB FTW69F0540Accident · Serious injuriesClosedSnow S2C · Millett, TXNTSB UNK65X0222Accident · No injuriesClosedSnow S2C600 · Ropesville, TX