NTSB investigations, 2003, WA
5 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 10 |
| 1984 | 6 |
| 1985 | 8 |
| 1986 | 3 |
| 1987 | 4 |
| 1988 | 3 |
| 1989 | 8 |
| 1990 | 7 |
| 1991 | 5 |
| 1992 | 12 |
| 1993 | 7 |
| 1994 | 8 |
| 1995 | 5 |
| 1996 | 6 |
| 1997 | 1 |
| 1998 | 9 |
| 1999 | 7 |
| 2000 | 10 |
| 2001 | 4 |
| 2002 | 7 |
| 2003 | 5 |
| 2004 | 9 |
| 2005 | 6 |
| 2006 | 2 |
| 2007 | 7 |
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 year(c.\"eventDate\") = 2003
AND 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\" = 220)
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 year(c."eventDate") = 2003 AND 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" = 220) 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 SEA04FA023Accident · 1 fatalField investigationFinal reportFairchild Swearingen SA227-AT · Spokane, WAThe pilot-in-command's failure to maintain proper glidepath alignment during an ILS approach in poor weather resulting in collision with trees and terrain. Contributing factors were the unreliable status of the primary (NAV 1) ILS receiver (leaving the pilot…NTSB SEA03CA200Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Basin City, WAClearance not maintained while on short approach to the runway. A factor was the corn stalks near the runway.NTSB SEA03LA141Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Newman Lake, WAThe pilot's failure to maintain clearance from an object while on final approach for landing. Trees and inadequate visual lookout were factors.NTSB SEA03LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Stuart Island, WAThe pilot's failure to maintain clearance while maneuvering to land. Contributing factors included the tree and the sunglare condition.NTSB SEA03LA101Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Royal City, WAThe pilot's failure to maintain clearance from a 20 foot high post while applying chemicals to an agricultural field, which resulted in impact damage to the right main landing gear, and ultimately to a collapse of the subject gear during the subsequent…