NTSB investigations: Fairchild FH-227
14 cases on aircraft the registry lists as Fairchild FH-227. 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
| 1966 | 1 |
|---|---|
| 1967 | 2 |
| 1968 | 2 |
| 1969 | 3 |
| 1972 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1983 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3373042'))
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 ('3373042'))
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 CHI83IA425Incident · No injuriesIncident investigationFinal reportFairchild FH-227 · Chicago, ILAfter taking off, the landing gear handle remained latched 'down' when the nosewheel did not center. The flightcrew thenused the nose gear steering override sw & turned the nosewheel until the 'off center light' extinguished. The override sw was placed 'off'…NTSB CHI82DA064Accident · No injuriesFinal reportFairchild Hiller 227C · Bloomington, INThe aircraft was being pre-positioned for a scheduled flight. During a visual approach to land, the captain (PIC) called for the flaps to be lowered in incremental settings (16.5, 27 & 40 deg). The flap handle was moved to the appropriate positions, but…NTSB MIA80IA080Incident · No injuriesClosedFairchild FH227E · West Palm Bch, FLNTSB NYC75AN119Accident · Minor injuriesClosedFairchild FH-227 · New Bedford, MANTSB DCA74AZ003Accident · 38 fatalClosedFairchild FH227B · St.Louis, MONTSB NYC73AN065Accident · Serious injuriesClosedFairchild FH227B · Winston-Salem, NCNTSB NYC70I0062Incident · No injuriesClosedFairchild FH-227 · Windsor Lock, CTNTSB DCA70A0005Accident · 14 fatalClosedFairchild FH227B · Glens Falls, NYNTSB CHI69A0092Accident · No injuriesClosedDouglas DC-8 · Chicago, ILNTSB DCA69A0004Accident · 32 fatalClosedFairchild FH227C · Hanover, NHNTSB NYC69I0029Incident · No injuriesClosedFairchild FH-227 · Manchester, NHNTSB NYC68I0021Incident · No injuriesClosedFairchild FH-227 · Massena, NYNTSB NYC67A0104Accident · No injuriesClosedFairchild FH-227 · East Boston, MANTSB NYC67I0084Incident · No injuriesClosedFairchild FH-227 · Newark, NJ