Skip to content

NTSB investigations: Fairchild M-62C(PT-23A)

24 cases on aircraft the registry lists as Fairchild M-62C(PT-23A). 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 ('3371630')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('3371630'))
  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 ('3371630'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN18LA197Accident · Minor injuriesLimited investigationFinal reportFairchild M 62C(PT-23A) · Wichita, KSA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s miscalculation of the fuel consumption rate during preflight planning.May 28, 2018 · N64176 · Substantial damage NTSB ERA14CA320Accident · No injuriesData collectionFinal reportFairchild M 62C(PT-23A) · Petersburg, VAThe flight instructor's failure to maintain control of the airplane during the landing attempt. Contributing to the accident was the changing wind conditions.May 22, 2014 · N60418 · Substantial damage NTSB NYC00LA197Accident · Serious injuriesLimited investigationFinal reportFairchild M-62C · Carthage, NYthe pilot's improper decision to depart with obstacles ahead which exceeded the climb capability of the airplane. Factors were the grass runway, and trees at the departure end of the runway.Jul 12, 2000 · N58741 · Substantial damage NTSB FTW88FA077Accident · Minor injuriesField investigationFinal reportFairchild M-62C · Arlington, TXFailure of the number six cylinder and piston.Mar 6, 1988 · N63739 · Substantial damage NTSB DEN87FA220Accident · Serious injuriesField investigationFinal reportFairchild PT-23 · Englewood, COThe plt & pax were flying to cheyenne, WY to put N64038 on static display. The plt stated the eng lost pwr drg climb- out at aprx 300' AGL. He was unable to restore pwr & maneuvered for an off arpt landing. A witness stated that after takeoff, N64038 lvld off…Aug 16, 1987 · N64038 · Destroyed NTSB LAX85LA113Accident · Minor injuriesLimited investigationFinal reportFairchild M-62C · Ballico, CAAt the conclusion of a local aerial application flt, acft experienced a loss of power and collided with trees during the subsequent forced landing. Examinaton of the aircraft revealed a broken fuel feed line aft of the wobble pump and no fuel in the lines or…Jan 10, 1985 · N68444 · Substantial damage NTSB FTW80FA089Accident · 1 fatalClosedFairchild M-62C · Plano, TXJul 2, 1980 · N2300M · Destroyed NTSB FTW77FRA10Accident · No injuriesClosedFairchild M-62-C · Houston, TXFeb 13, 1977 · N54375 · Substantial damage NTSB LAX76FVG10Accident · No injuriesClosedFairchild M-62C · Adelanto, CAAug 2, 1975 · N63820 · Substantial damage NTSB MKC74FCQ04Accident · Serious injuriesClosedFairchild M62C · Garden City, KSAug 3, 1973 · N57606 · Substantial damage NTSB NYC73FIA05Accident · No injuriesClosedFairchild PT-23 · Warrenton, VAAug 31, 1972 · N11113 · Destroyed NTSB LAX71FUM31Accident · Serious injuriesClosedFairchild M-62C · Chula Vista, CAMar 9, 1971 · N57064 · Substantial damage NTSB IAD71FIG17Accident · No injuriesClosedFairchild M-62C · Baltimore, MDMay 24, 1970 · N52020 · Substantial damage NTSB SEA69D0258Accident · No injuriesClosedFairchild M-62 · Bruneau, IDMay 22, 1969 · N56110 · Substantial damage NTSB CHI70F0087Accident · Serious injuriesClosedFairchild M-62C · Watertown, WIApr 20, 1969 · N63714 · Destroyed NTSB OAK69A0003Accident · Minor injuriesClosedPiper PA-25 · Crows Lndng, CAJul 16, 1968 · N4574Y · 2 aircraft · Destroyed NTSB DEN68D0059Accident · No injuriesClosedFairchild WM62C · Clovis, NMJul 28, 1967 · N48706 · Substantial damage NTSB SEA67D0350Accident · No injuriesClosedFairchild M62 · Rome, ORJun 15, 1967 · N56110 · Substantial damage NTSB OAK66F0097Accident · No injuriesClosedFairchild WM-62 · Salinas, CAAug 15, 1965 · N48888 · Substantial damage NTSB OAK66F0027Accident · Minor injuriesClosedFairchild M62 · Westley, CAJul 22, 1965 · N68444 · Substantial damage NTSB SEA66F0057Accident · No injuriesClosedFairchild M62C · Homedale, IDJun 18, 1965 · N56110 · Substantial damage NTSB SEA65D0060Accident · No injuriesClosedFairchild W62M · Adrian, ORMay 11, 1965 · N56110 · No damage NTSB UNK64X3540Accident · No injuriesClosedFairchild WM62C · Salome, AZAug 22, 1964 · N57064 · Substantial damage NTSB UNK64X3201Accident · Serious injuriesClosedFairchild M62C · Mojave, CAAug 3, 1964 · N55921 · Destroyed