NTSB investigations: Fairchild 6-440 series, CA
11 cases on aircraft whose registry engine model is Fairchild 6-440 series. 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
| 1965 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1991 | 1 |
| 2004 | 1 |
| 2015 | 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\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('26003'))
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" = 'CA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('26003'))
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 WPR15FA200Accident · 1 fatalField investigationFinal reportManiscalco Great Lakes · Corona, CAThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack while maneuvering, which resulted in a stall/spin at too low an altitude to allow recovery. Contributing to the accident was the pilot's improper…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 LAX91LA322Accident · Serious injuriesLimited investigationFinal reportExperimental Brown 2 · San Carlos, CAThe failure of the pilot to maintain control of the aircraft during the attempted go around.NTSB LAX79DVA64Accident · No injuriesClosedManiscalco Grtlks · Madera, CANTSB OAK77DVD26Accident · No injuriesClosedGreat Lakes 2T1A · Sonoma, CANTSB OAK71FVG08Accident · Serious injuriesClosedFairchild M-62-A · Paradise, CANTSB OAK69D0016Accident · No injuriesClosedFairchild PT-19 · Paradise, CANTSB LAX68F0126Accident · Minor injuriesClosedFairchild PT-26 · Saugus, CANTSB LAX67F0258Accident · Minor injuriesClosedFairchild 24H · Burbank, CANTSB LAX66F0167Accident · No injuriesClosedFairchild 24 · Santa Paula, CANTSB LAX66D0138Accident · No injuriesClosedCurtiss-Wrt 2000 · San Diego, CA