NTSB investigations: Fairchild F-27

10 cases on aircraft the registry lists as Fairchild F-27. 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

19622026

NTSB investigations: Fairchild F-27 per year, 1962–2026: 10 cases
1962	2
1963	2
1967	1
1975	1
1980	2
1985	2

Where

Open the map

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 ('3373002')) 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 ('3373002'))
  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 ('3373002'))
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 FTW86LA006Accident · No injuriesLimited investigationFinal reportFairchild F-27 · Houston, TXAcft veered left off the runway shortly after touchdown, collapsing the nose gear. Winds at the time would have resulted in direct crosswind of 9 kns. The crew that was contracted to ferry the acft noted, when they picked it up, that there were several open…Oct 7, 1985 · N4302F · Substantial damage NTSB CHI85IA143Incident · No injuriesIncident investigationFinal reportFairchild F-27 · Champaign, ILDuring engine start a fuel line running between the fuel pump and the differential pressure switch ruptured and caused a small fire. The crew observed a fire warning light,aborted the start procedure and activated the fire extingui shing system which put the…Mar 20, 1985 · N386BA · Minor damage NTSB ATL81IA004Incident · No injuriesClosedFairchild F-27 · Raliegh, NCOct 9, 1980 · N112TA · Minor damage NTSB NYC80IA073Incident · No injuriesClosedFairchild F-27 · Flushing, NYAug 19, 1980 · N112TA · Minor damage NTSB DCA76AZ004Accident · 10 fatalClosedFairchild F-27B · Gambell, AKAug 30, 1975 · N4904 · Destroyed NTSB SEA67A0047Accident · 4 fatalClosedFairchild F-27 · Klamath Fall, ORMar 10, 1967 · N2712 · Destroyed NTSB UNK63X0104Accident · Serious injuriesClosedFairchild F-27 · Calgary, CanadaAug 24, 1963 · N2707 · Substantial damage NTSB FTW63A0119Accident · 3 fatalClosedFairchild F-27 · Salt Lake City, UTJan 17, 1963 · N2703 · Destroyed NTSB MKC62A0006Accident · No injuriesClosedFairchild F-27 · Waterloo, IAFeb 25, 1962 · N4302F · Substantial damage NTSB MIA62A0001Accident · No injuriesClosedFairchild F-27 · Charlotte, NCJan 1, 1962 · N2703R · Substantial damage