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.

NTSB MIA00LA115Accident · Serious injuriesLimited investigationFinal reportBeech 1900 · Miami, FLInadequate visual lookout by the driver of the vehicle.Mar 19, 2000 · N199GA · Minor damageNTSB NYC00LA086Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-30F · Newark, NJThe tug operator's inadequate visual lookout.Mar 1, 2000 · N302FE · Substantial damageNTSB 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.Feb 21, 2000 · N1403M · Substantial damageNTSB IAD00LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Norridgewock, MEthe student pilot's loss of directional control during the takeoff roll.Feb 13, 2000 · N5679R · Substantial damageNTSB NYC00IA076Incident · No injuriesIncident investigationFinal reportCessna 182P · Hartford, CTThe pilot's failure to maintain a visual lookout.Feb 9, 2000 · N1420S · Minor damageNTSB 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.Jan 16, 2000 · N6407C · Substantial damageNTSB 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.Jan 9, 2000 · N2292M · Substantial damage