NTSB investigations, 2000, IN

5 cases where the first occurrence was “Loss of control - on ground/water”.

Cases per year

19822026
NTSB investigations, 2000, IN per year, 1982–2026: 108 cases
198211
198310
19843
19855
19866
19879
19883
19896
199011
19915
19924
19932
19943
19952
19964
19972
19983
19993
20005
20022
20032
20041
20053
20063

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\") = 2000
    AND c.\"eventStateOrRegion\" = 'IN' 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\" = 260)
  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 CHI01LA058Accident · No injuriesLimited investigationFinal reportCessna 172N · Elkhart, INThe loss of directional control by the student pilot and the inadequate remedial action and inadequate supervision by the certified flight instructor. Factors were the snow and ice covered runway and the snowbank.Dec 30, 2000 · N6326F · Substantial damageNTSB CHI00TA306Accident · Minor injuriesFinal reportBell 47G-5A · Economy, INThe pilot failed to maintain control of the helicopter while attempting a landing on unsuitable terrain. A factor associated with the accident was the grass covered, down slope in the terrain.Sep 22, 2000 · N14841 · Substantial damageNTSB CHI00LA233Accident · No injuriesLimited investigationFinal reportCessna 180 · Jeffersonville, INThe pilot failed to maintain directional control of the airplane while landing. A factor associated with the accident was the crosswind.Aug 1, 2000 · N1774C · Substantial damageNTSB CHI00LA150Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Salem, INthe inadequate compensation for the wind conditions and the failure of the pilot to maintain directional control. A factor to the accident was the crosswind condition.Jun 3, 2000 · N1686P · Substantial damageNTSB CHI00LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Goshen, INthe failure of the student pilot to maintain directional control on the takeoff roll. Factors to the accident were the lack of experience of the student pilot and the improper use of the throttle.May 22, 2000 · N68182 · Substantial damage