NTSB investigations, DC
3 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1994 | 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\" = 'DC' 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\" = 310)
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" = 'DC' 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" = 310) 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 NYC94LA144Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-8-311 · Washington, DCThe vehicle operator's improper handling of the baggage tractor resulting in loss of control of a second baggage tractor being pushed and its subsequent collision with the airplane.NTSB BFO85IA074Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Washington, DCNorthwest flight 78 (NW78), a B-757, was parked at gate 17 facing east with mobile passenger lounge (mpl) docked at L1 door. United 52, a DC-10, taxied in easterly direction by left side of NW78, then turned right to southeasterly heading to follow lead-in…NTSB BFO84IA005Incident · No injuriesIncident investigationFinal reportBoeing 727-22 · Washington, DCMishap acft, new york air flight 306 (nya 306) followed a Boeing 727, united flight 827 (ual 827), to the run-up area and positioned in the #2 spot for takeoff, anticipating ual 827 would receive takeoff clearance first. Nya 306 was cleared first for takeoff…