Final NTSB investigations: Taylorcraft 19
9 cases on aircraft the registry lists as Taylorcraft 19. 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
| 1965 | 1 |
|---|---|
| 1968 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1980 | 1 |
| 1996 | 1 |
| 2001 | 1 |
| 2007 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850902'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850902'))
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 ANC08CA005Accident · No injuriesData collectionFinal reportTaylorcraft F-19 · Wasilla, AKThe flight instructor's delayed remedial action during the takeoff roll, which resulted in an overrun during an aborted takeoff, and a collision with trees.NTSB ANC01LA040Accident · No injuriesLimited investigationFinal reportTaylorcraft 19 · Salcha, AKThe pilot's failure to compensate for a tailwind during takeoff, and his delay in aborting the takeoff. Factors in the accident were a tailwind, and snow-covered terrain.NTSB CHI96LA305Accident · No injuriesLimited investigationFinal reportTaylorcraft 19 · Shakopee, MNfailure of the right main landing gear shock strut due to internal corrosion. The restriction to inspection of the strut was a related factor.NTSB ATL81DID03Accident · Minor injuriesClosedTaylorcraft BC12-D · Scottsville, VANTSB ANC75DAG16Accident · No injuriesClosedTaylorcraft BC12-D · Skwentna, AKNTSB ANC73DAG67Accident · No injuriesClosedTaylorcraft BC12-D · Anchorage, AKNTSB CHI71FBM05Accident · Serious injuriesClosedTaylorcraft 19 · Dowagiac, MINTSB NYC68D0462Accident · No injuriesClosedTaylorcraft BC12D1 · Mansfield, MANTSB MKC66D0166Accident · No injuriesClosedTaylorcraft 19 · Eagle Grove, IA