NTSB investigations: Fairchild 6-440 series, TX
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
| 1971 | 1 |
|---|---|
| 1975 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 2001 | 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.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" = '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.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 FTW04FA232Accident · 2 fatalField investigationFinal reportFairchild M-62A-3 · Corsicana, TXThe loss of engine power due to a faulty carburetor and the pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during the forced landing after takeoff.NTSB FTW01FA100Accident · 1 fatalField investigationFinal reportFairchild PT-19A · Midland, TXthe pilot's failure to maintain airspeed which resulted in an inadvertant stall during initial takeoff climb. A contributing factor was wind gusts.NTSB FTW98LA402Accident · No injuriesLimited investigationFinal reportFairchild M-62A-3 · Amarillo, TXThe inadvertent stall due to the pilot's failure to maintain proper airspeed during the takeoff.NTSB FTW93LA264Accident · Minor injuriesLimited investigationFinal reportFairchild M-62A · San Antonio, TXFuel starvation induced power loss due to the pilot's improper fuel tank selection and his failure to switch tanks after the power loss. A factor was the lack of suitable terrain onto which a forced landing could be executed.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 FTW85LA082Accident · Serious injuriesLimited investigationFinal reportFairchild M-62A · San Antonio, TXA total pwr loss was experienced while manuevering over an airport at about 250 ft AGL. The acft collided with rough terrain during the forced landing. Visual inspection of the acft fuel system indicated that the pwr loss was due to fuel exhaustion.NTSB FTW82FA011Accident · 1 fatalClosedFairchild M-62A · Celina, TXNTSB FTW78FPA31Accident · No injuriesClosedFairchild M-62A · Sherman, TXNTSB FTW77FRA10Accident · No injuriesClosedFairchild M-62-C · Houston, TXNTSB FTW75DPD46Accident · Minor injuriesClosedFairchild PT-26 · Justin, TXNTSB FTW72FRA07Accident · No injuriesClosedFairchild 24R-26 · Houston, TX