NTSB investigations, CA
7 cases where NTSB found Towing and taxiing.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2025 | 1 |
Where
Latest 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\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010109'))
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" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010109')) 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 WPR26LA009Accident · No injuriesClass 4 · LimitedFinal reportMooney M20C · Watsonville, CAThe pilot’s decision to program avionics during taxi, resulting in an inadvertent throttle input and collision with a hangar.NTSB DCA19CA186Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 757 · San Francisco, CAfailure of the ground crew to maintain clearance from the parked airplane during pushback.NTSB DCA16CA139Accident · No injuriesData collectionFinal reportBombardier CL 600 2B19 · San Francisco, CAThe tug driver's failure to comply with the wing walkers direction to stop, which resulted in the towed airplane colliding with N961SW.NTSB DCA15CA176Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Oakland, CAinadvertent jet blast, resulting in debris striking ground operations personnel.NTSB DCA11CA073Accident · No injuriesData collectionFinal reportBoeing 757-222 · San Fransico, CAThe ramp personnel's failure to visually verify the position of the jetway before beginning the airplane pushback.NTSB WPR10CA451Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Paradise Lakes Estates, CAThe pilot's failure to maintain clearance from a fence during taxi.NTSB SEA08LA182Accident · Serious injuriesLimited investigationFinal reportBoeing 777-300 · San Francisco, CAThe ground crewman's failure to follow the tow bar disconnect standard operating procedures.