NTSB investigations, 2000, PA

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

Cases per year

19822026
NTSB investigations, 2000, PA per year, 1982–2026: 128 cases
19826
19837
198410
19857
19865
19875
19888
19893
19905
19916
19925
19935
19941
19953
19963
19973
19982
19994
20008
20014
20023
20034
20047
20055
20063
20076

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\" = 'PA' 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 IAD01LA003Accident · Minor injuriesLimited investigationFinal reportPitts S-1A · Mount Pocono, PAPilot's inadequate compensation for wind conditions during landing. A factor was the crosswind.Oct 13, 2000 · N800AS · Substantial damageNTSB NYC00LA264Accident · No injuriesLimited investigationFinal reportAeronca 11AC-991 · Gettysburg, PAThe pilot's failure to maintain control of the airplane after landing which resulted in the inadvertent ground loop.Sep 17, 2000 · N9354E · Substantial damageNTSB IAD00LA077Accident · No injuriesLimited investigationFinal reportFoulke Europa TRI-GEAR · Doylestown, PAThe pilot's failure to maintain directional control during landing.Aug 19, 2000 · N82716 · Substantial damageNTSB NYC00LA166Accident · No injuriesLimited investigationFinal reportCessna 182 · Freedom, PAThe pilot's failure to maintain aircraft control. Factors were the soft runway, and that the pilot exceeded the aircraft's weight and balance.Jun 17, 2000 · N5746B · Substantial damageNTSB NYC00LA126Accident · No injuriesLimited investigationFinal reportCessna 185F · Pottstown, PAThe second pilot's inadequate compensation for wind conditions and the inadequate supervision of the flight instructor. Factors related to the accident were the crosswind and gusting wind conditions.Apr 30, 2000 · N6535E · Substantial damageNTSB NYC00LA110Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Waynesburg, PAThe private pilot's inadequate compensation for wind conditions and the flight instructor's delay in remedial action. A factor in the accident was the gusting wind conditions.Mar 26, 2000 · N88340 · Substantial damageNTSB NYC00LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Hazelton, PAThe pilot's failure to maintain directional control while landing with a crosswind.Mar 1, 2000 · N67639 · Substantial damageNTSB IAD00LA016Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Waynesburg, PAthe pilot's failure to maintain aircraft control during the landing roll-out.Jan 9, 2000 · N2735Z · Substantial damage