NTSB investigations, WA
7 cases where the first occurrence was “Wheels up landing”.
Cases per year
| 1996 | 1 |
|---|---|
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 3 |
| 2004 | 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\" = 'WA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 232)
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" = 'WA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 232) 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 SEA04CA144Accident · No injuriesData collectionFinal reportPiper Aerostar 602P · Seattle, WAThe landing gear extention not performed by the pilot.NTSB SEA03LA018Accident · No injuriesLimited investigationFinal reportHawker Siddeley DH-125 · Seattle, WAThe landing gear down and locked was not verified prior to landing. The checklist was not followed, and an inoperative landing gear warning horn were factors.NTSB SEA02LA139Accident · No injuriesLimited investigationFinal reportCessna R182 · Puyallup, WARestricted movement of the left main landing gear resulting in the gear not extending for the landing. A misaligned brake line was a factor.NTSB SEA02LA043Accident · No injuriesLimited investigationFinal reportBeech G35 · Anacortes, WAThe pilot's inadvertent failure to lower the landing gear prior to touchdown.NTSB SEA01LA071Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Gig Harbor, WAThe pilot's failure to extend the airplane's landing gear while landing.NTSB SEA00LA011Accident · No injuriesLimited investigationFinal reportBeech A36TC · Pasco, WAThe pilot's failure to extend the landing gear. Factors include a blocked view of the landing gear light indicating system.NTSB SEA96LA045Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Camas, WAFailure of the pilot to ensure that the landing gear was extended before landing.