NTSB investigations: Fairchild M-62A, TX
4 cases on aircraft the registry lists as Fairchild M-62A. 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
| 1981 | 1 |
|---|---|
| 1984 | 1 |
| 1993 | 1 |
| 2001 | 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.aircraft_model_code IN ('3371604'))
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.aircraft_model_code IN ('3371604'))
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 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 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 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, TX