NTSB investigations: Piper PA-11, TX
11 cases on aircraft the registry lists as Piper PA-11. 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 | 2 |
|---|---|
| 1968 | 3 |
| 1973 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1993 | 1 |
| 2010 | 1 |
| 2019 | 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101102', '7101106'))
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101102', '7101106'))
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 GAA19CA317Accident · No injuriesData collectionFinal reportPiper PA 11 · Paducah, TXThe pilot's failure to maintain directional control during the landing on a road in crosswind conditions, which resulted in the airplane exiting the road and subsequently nosing over.NTSB CEN10CA419Accident · No injuriesData collectionFinal reportPiper PA-11 · Leander, TXThe pilot’s failure to maintain clearance from trees during approach.NTSB DEN93LA079Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Burkburnett, TXThe disconnection of the up elevator cable from the control horn. A factor was the incorrect installation of the bolt and castle nut by unknown maintenance personnel.NTSB FTW77FA015Accident · 2 fatalClosedPiper PA-11 · Comstock, TXNTSB FTW76DRG27Accident · No injuriesClosedPiper PA-11 · Chapman Ranch, TXNTSB FTW74DPA10Accident · Minor injuriesClosedPiper PA-11 · Waxahachie, TXNTSB FTW69D0348Accident · No injuriesClosedPiper PA-11 · Plano, TXNTSB FTW68D0505Accident · No injuriesClosedPiper PA-11 · Lubbock, TXNTSB FTW68D0463Accident · No injuriesClosedPiper PA-11 · El Paso, TXNTSB FTW67D0299Accident · No injuriesClosedPiper PA-11 · Terrell, TXNTSB FTW67D0182Accident · Serious injuriesClosedPiper PA-11S · Lewisville, TX