NTSB investigations: Taylorcraft F21
7 cases on aircraft the registry lists as Taylorcraft F21. 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
| 1984 | 1 |
|---|---|
| 1999 | 1 |
| 2003 | 1 |
| 2012 | 1 |
| 2018 | 1 |
| 2022 | 1 |
| 2023 | 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 ('8850906'))
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 ('8850906'))
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 CEN23LA351Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft F21 · Holliday, TXA loss of engine power for reasons that could not be determined, which resulted in impact with terrain.NTSB ANC22LA060Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft F21 · Kenai, AKThe pilot’s failure to maintain adequate distance from a tree while landing.NTSB GAA18CA302Accident · No injuriesData collectionFinal reportTaylorcraft F21 · Payette, IDThe student pilot’s failure to maintain directional control during landing with a crosswind and his subsequent failure to maintain airspeed during an aborted landing, which resulted in a collision with terrain and nose-over.NTSB ANC12LA096Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F21 · Willow, AKThe pilot’s failure to maintain control of the airplane after a loss of engine power during takeoff due to carburetor ice.NTSB LAX03LA071Accident · No injuriesLimited investigationFinal reportTaylorcraft F21 · Payson, AZfailure of the pilot to maintain directional control of the airplane during landing.NTSB CHI00LA034Accident · No injuriesLimited investigationFinal reportTaylorcraft F-21 · Houlton, WIthe mechanic failed to torque the rod cap bolt during the major engine overhaul. Factors relating to the accident included the rough field and the collapsed landing gear.NTSB LAX84LA291Accident · No injuriesLimited investigationFinal reportTaylorcraft F21 · Payson, AZThe acft was landed 200 ft short of the rwy in bushes after the engine hesitated during the plts application of throttle in an attempt to reach the rwy. An FAA inspector found the magneto timing set to 23 plus degrees rather than the prescribed 20 degrees.