NTSB investigations, 2000, FL

4 cases where the first occurrence was “Miscellaneous/other”.

Cases per year

19832026
NTSB investigations, 2000, FL per year, 1983–2026: 88 cases
19831
19843
19854
19867
19876
19884
19897
19903
199110
19931
19944
19953
19971
19982
19998
20004
20015
20021
20032
20041
20053
20064
20074

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\" = 'FL' 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\" = 430)
  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 MIA01LA010Accident · No injuriesLimited investigationFinal reportJim Price Pitts Special S · Indiantown, FLThe failure of the pilot of N56JP, during landing rollout, to see and avoid N49713, who was turning off the runway after landing from the opposite direction, resulting in the 2 aircraft colliding on the runway.Oct 21, 2000 · N56JP · 2 aircraft · Substantial damageNTSB MIA00LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Immokalee, FLThe inadequate supervision of the pilot rated student by the CFI for her failure to note that the fuel selector was positioned to an empty fuel tank. Also, failure of the CFI to attain the proper rate of descent at touchdown resulting in a hard landing.…Jul 16, 2000 · N980AC · Substantial damageNTSB MIA00IA164Incident · No injuriesIncident investigationFinal reportBeech 1900C · Fort Lauderdale, FLThe failure of the first officer to comply with procedures and directives for his failure to assure that the forward airstair door was closed and locked. A contributing factor in the incident was the inoperative annunciation system of the forward airstair…May 19, 2000 · N154GA · Minor damageNTSB MIA00LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Englewood, FLThe failure of the pilot to retract the flaps from the fully extended position following the last landing resulting in the failure to maintain airspeed and subsequent descent for a forced landing. A contributing factor in the accident was the pilot's…Feb 8, 2000 · N6630F · Substantial damage