NTSB investigations: Fairchild 24R-40
9 cases on aircraft the registry lists as Fairchild 24R-40. 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 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 2004 | 2 |
| 2012 | 1 |
| 2017 | 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 ('3370508'))
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 ('3370508'))
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 GAA17CA295Accident · Minor injuriesData collectionFinal reportFairchild 24R · Catlett, VAThe pilot’s selection of an unsuitable landing area, which resulted in the airplane impacting wheat stalks and a subsequent nose-over.NTSB ERA12CA415Accident · No injuriesData collectionFinal reportFairchild 24R-40 · Smyrna, TNThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB NYC05LA010Accident · Serious injuriesLimited investigationFinal reportFairchild 24R-40 · Custar, OHThe pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with terrain. A factor was a crosswind.NTSB LAX04CA244Accident · No injuriesData collectionFinal reportFairchild 24R-40 · Lincoln, CAthe pilot's failure to maintain directional control and inadequate compensation for gusty wind conditions, which resulted in a ground loop and collision with the runway.NTSB LAX86LA245Accident · Minor injuriesLimited investigationFinal reportFairchild 24R-40 · Marysville, CAThe acft's left wing spar failed while the acft was in level flt. The plt was able to regain partial control of the acft and landed it in a plowed field. The acft owner reported he had previously replaced the right wing due to deterioration of the wood…NTSB LAX83FVG01Accident · No injuriesFinal reportFairchild 24 · Marysville, CAThe aircraft groundlooped during landing. The pilot said the right brake grabbed and swerved the aircraft. An investigaiton revealed no malfunction.NTSB NYC66F0586Accident · Minor injuriesClosedFairchild R-24 · Red Hook, NYNTSB NYC65F0098Accident · No injuriesClosedFairchild 24R-40 · Winterport, MENTSB UNK64X2138Accident · Serious injuriesClosedFairchild F24 · Egegik, AK