NTSB investigations, 2000
57 cases where the first occurrence was “On ground/water collision with object”.
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 year(c.\"eventDate\") = 2000
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 year(c."eventDate") = 2000 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 MIA00LA115Accident · Serious injuriesLimited investigationFinal reportBeech 1900 · Miami, FLInadequate visual lookout by the driver of the vehicle.NTSB NYC00LA086Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-30F · Newark, NJThe tug operator's inadequate visual lookout.NTSB CHI00LA076Accident · Serious injuriesLimited investigationFinal reportFokker F28 MK100 · Chicago, ILthe driver of the refueling truck fell asleep which resulted in him not maintaining clearance with the parked aircraft. Factors associated with the accident were severe obstructive sleep apnea and significant hypersomnolence which resulted in chronic fatigue.NTSB IAD00LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Norridgewock, MEthe student pilot's loss of directional control during the takeoff roll.NTSB NYC00IA076Incident · No injuriesIncident investigationFinal reportCessna 182P · Hartford, CTThe pilot's failure to maintain a visual lookout.NTSB MIA00LA068Accident · No injuriesLimited investigationFinal reportDana A. Moore Danamite · Smyrna, TNthe pilot's excessive taxiing speed and failure to maintain adequate clearance from objects, resulting in the gyroplane's main rotor colliding with a fence and subsequent damage to the aircraft.NTSB DEN00LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Pueblo, COCollision with a deer during landing roll. Factors were a dark night and lack of wildlife control devices on the airport.