NTSB investigations: Fairchild 24R-46
12 cases on aircraft the registry lists as Fairchild 24R-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 |
|---|---|
| 1968 | 1 |
| 1969 | 2 |
| 1971 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1986 | 2 |
| 2025 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3370514'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3370514'))
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 CEN25LA245Accident · No injuriesClass 4 · LimitedFinal reportFairchild 24R · Greeley, COThe pilot’s inability to maintain directional control during landing due to excessive wear in the tailwheel steering assembly.NTSB ATL86FEI08Accident · Serious injuriesFinal reportFairchild 24R-46 · Canton, OHThe plt reported that he was taking off after making a touch and go ldg; as he 'pushed (the) throttle forward on lift-off (the) engine began to quit'. The engine subsequently quit altogether at about 200-300 feet AGL over the departure end of the rwy.…NTSB FTW86LRG12Accident · No injuriesFinal reportFairchild 24R-46A · Lakeway, TXThe dual instructional flight terminated in a crosswind landing with the rated pilot receiving dual instruction manipulating the controls. During the landing rollout directional control was lost and the aircraft veered to the left. According to the instructor…NTSB DEN77DQA18Accident · No injuriesClosedFairchild 24R-46 · Gallup, NMNTSB IAD77DKW07Accident · No injuriesClosedFairchild 24 · Rockwood, TNNTSB SEA75DYE18Accident · No injuriesClosedFairchild 24 · Oak Harbor, WANTSB FTW72FRA07Accident · No injuriesClosedFairchild 24R-26 · Houston, TXNTSB MKC70F0307Accident · No injuriesClosedFairchild 24R-46 · Eudora, KSNTSB OAK70D0192Accident · No injuriesClosedFairchild 24 · Santa Rosa, CANTSB CHI69A0058Accident · No injuriesClosedCessna 150E · Sandwich, ILNTSB UNK64X3687Accident · No injuriesClosedFairchild 24 · Deridder, LANTSB UNK64X1884Accident · No injuriesClosedFairchild 24R46 · Broomfield, CO