NTSB investigations
57 cases where the sequence of events included Airport occurrence.
Cases, newest first
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '070' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '070' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CHI08CA265Accident · No injuriesData collectionFinal reportPiper PA-28-161 · New Ulm, MNThe failure of airport personnel to correct a hazardous condition on the airport. A factor was the uncovered manhole.NTSB CHI08CA231Accident · No injuriesData collectionFinal reportWeatherly 201B · Creston, ILThe pilot's selection of the unsuitable terrain next to the runway to avoid the landing traffic. Contributing to the accident was the hill in the middle of the runway that blocked the pilot's view of the other traffic and the high vegetation near the runway.NTSB OPS08IA010Incident · No injuriesIncident investigationFinal reportCessna 172 · Teterboro, NJProbable Cause The probable cause of this incident was the TEB ground controller's failure to direct N316AS to hold short of runway 24 when issuing taxi instructions to the aircraft as required FAA Order 7110.65, paragraph 3-7-2 (2a); Taxi and Ground Movement…NTSB OPS08IA007Incident · No injuriesIncident investigationFinal reportBoeing 737-700 · Seattle, WAThe diverted attention during taxi of the flight crew in the other aircraft. Contributing to the incident was the air traffic control clearance was not followed by the flight crew of the other aircraft.NTSB LAX08CA125Accident · Minor injuriesData collectionFinal reportGrumman AA-5A · Atlanta, IDThe pilot's failure to attain and maintain an adequate airspeed during the takeoff to clear trees during the initial climb. Contributing factors were the soft and rough nature of the short runway surface.NTSB CHI08CA081Accident · No injuriesData collectionFinal reportCessna 425 · Cahokia, ILThe pilot not maintaining clearance from the runway sign during taxi for takeoff. A factor contributing to the accident was an icy taxiway.NTSB LAX08CA053Accident · Minor injuriesData collectionFinal reportCessna 172N · Beaver Marsh, ORThe pilot's inadequate in-flight planning/decision to land on a snow covered runway without first determining the depth of the snow.