NTSB investigations: Taylorcraft F19
5 cases on aircraft the registry lists as Taylorcraft F19, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 2 |
|---|---|
| 1996 | 1 |
| 2000 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850904')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 ('8850904')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 IAD05LA049Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Northampton, MAThe pilot/owner's improper decision to conduct the flight with a known deficiency in equipment, which resulted in a loss of control when the tailwheel springs became disconnected. Factors were the disconnection of the tailwheel springs, the snow bank, and…NTSB NYC00LA080Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F19 · West Lafayette, OHwas a delayed decision of the pilot to abort the landing. Factors were the wet runway, and the tail winds that prevailed in the area.NTSB IAD96LA104Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Mitchellville, MDthe pilot's failure to maintain directional control of the aircraft during the landing roll. Related factors were the gusty crosswind conditions.NTSB ANC82DAG20Accident · No injuriesFinal reportTaylorcraft F-19 · Kenai, AKThe pilot-in-command had just purchased the aircraft and was in the porcess of improving her skills. The other occupant was an instructor pilot. While landing on runway 01 with a wind from 310 degrees at 14 knots, the aircraft bounced and veered to the right.…NTSB LAX82DVM10Accident · No injuriesFinal reportTaylorcraft F19 · Mt. Hamilton, CAAfter landing, the pilot's right heel slipped off of the right heel brake while he was applying brakes. Subsequently, the aircraft veered to the left before he released the left brake. The right main gear collapsed as the aircraft stopped in a small ditch…