Final NTSB investigations: Fairchild 24W-46
14 cases on aircraft the registry lists as Fairchild 24W-46. 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 | 2 |
|---|---|
| 1965 | 3 |
| 1966 | 1 |
| 1968 | 1 |
| 1971 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1985 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 2002 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3370626'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3370626'))
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 LAX02LA099Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Marana, AZThe left brake failed due to a stuck piston.NTSB MIA95LA189Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Callahan, FLLoss of engine power due to failure of the magnetos. A factor in the accident was the lack of suitable terrain for the forced landing.NTSB DEN92LA063Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Brighton, COThe pilot's inadequate visual lookout.NTSB NYC85LA076Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Andover, NJThe plt reported that the wind was from 300 deg at 12 gusting 20 KTS. While on final apch to land, the acft encountered a gust & settled prematurely. It drifted to the left & the left wheel entered a grassy area. The plt initiated corrective action, then the…NTSB MIA78DLD04Accident · No injuriesClosedFairchild F24 · Titusville, FLNTSB SEA76FYC61Accident · Serious injuriesClosedFairchild 24W-46 · Oregon City, ORNTSB ANC72AK014Accident · 3 fatalClosedFairchild 24W46 · Lino Lakes, MNNTSB CHI69D0302Accident · No injuriesClosedFairchild 24W46 · E.Liverpool, OHNTSB LAX67F0250Accident · No injuriesClosedFairchild 24 · Pacoima, CANTSB DEN66D0192Accident · No injuriesClosedFairchild F24 · Tucson, AZNTSB MKC65F0079Accident · No injuriesClosedFairchild 24W-46 · Minneapolis, MNNTSB LAX65F0030Accident · No injuriesClosedFairchild 24W · San Fernando, CANTSB UNK65X0861Accident · Minor injuriesClosedFairchild 24W · Salinas, CANTSB UNK64X1698Accident · No injuriesClosedFairchild 24W46 · Angels Camp, CA