Fatal NTSB investigations: Fairchild M-62A-3
4 cases on aircraft the registry lists as Fairchild M-62A-3. 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 | 1 |
|---|---|
| 1987 | 1 |
| 2004 | 1 |
| 2005 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3371618'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3371618'))
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 ATL05FA098Accident · 2 fatalField investigationFinal reportFairchild M-62A-3 · Williamson, GAThe pilot's failure to follow the before takeoff checklist and attempted a takeoff with flaps extended, which resulted in an in-flight collision with trees.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 ATL88FA066Accident · 2 fatalField investigationFinal reportFairchild M-62A-3 · Monroe, NCReptdly, the flt purpose was to administer a bfr to the plt/owner of the acft. The first takeoff was aborted. The acft deptd again without an apparent problem. After about 30 minutes, the apt mgr heard and saw the acft in a vertical descent and rotating about…NTSB CHI65A0105Accident · 2 fatalClosedFairchild PT-19 · St.Clairsville, OH