NTSB investigations
8 cases where the first occurrence was “Tail gear collapsed”.
Cases per year
| 1983 | 3 |
|---|---|
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2001 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 193) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 193) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 SEA01LA137Accident · No injuriesLimited investigationFinal reportPiper PA-20-135 · Redmond, ORThe pilot's inadequate compensation for wind conditions during landing. A factor was variable winds.NTSB ANC97LA123Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Kaktovik, AKThe pilot's selection of an unsuitable takeoff area. A factor related to the accident was the rocky terrain.NTSB MIA95LA092Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Opa Locka, FLCollapse of the tailwheel gear assembly, due to improper installation of a nut by maintenance personnel.NTSB CHI95LA049Accident · Serious injuriesLimited investigationFinal reportDouglas DC-8-71F · Chicago, ILthe failure of the ground crew to maintain an appropriate center of gravity while downloading cargo from the airplane. A factor was the ground crew's failure to follow established downloading procedures.NTSB CHI93LA369Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Festus, MOa fatigue failure of the tailwheel spring.NTSB ATL84LA018Accident · No injuriesLimited investigationFinal reportLanny Rundell Quickie Q2 · Vicksburg, MSWhile on the landing roll, the acft was rolling straight down the centerline of the rwy when the plt felt a bump & rear of the acft dropped. At the same time, all directional control was lost & the rudder pedals went forward to the firewall. The acft started…NTSB ATL83FU007Accident · Minor injuriesFinal reportTeratorn Tierra II · Dallas, NCThe plt-in-command (PIC) stated he was taking off on a training flt with a student, using a 2 place, ultralight vehicle. During the takeoff roll, the rubber tread separated from the tailwheel & it began to dig into the airstrip. The PIC reported that after…NTSB MIA83LA155Accident · No injuriesLimited investigationFinal reportBeech G18S · Jacksonville, FLThe plt reported that during the landing roll, while rolling on all 3 gear, the tailwheel failed & steered sideways causing the acft to veer off the rwy. An investigation revealed the tailwheel truss axle had failed. A further inspection revealed that 50% of…