NTSB investigations, 2009, NJ

7 cases where the sequence of events included Runway excursion.

Cases per year

20082026
NTSB investigations, 2009, NJ per year, 2008–2026: 61 cases
20083
20097
20103
20117
20126
20131
20142
20154
20165
20172
20183
20192
20203
20213
20224
20232
20253
20261

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\") = 2009
    AND c.\"eventStateOrRegion\" = 'NJ' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 ERA09LA468Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Mount Holly, NJA loss of directional control during landing for undetermined reasons.Aug 18, 2009 · N7556H · Substantial damageNTSB ERA09CA437Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Lincoln Park, NJThe pilot's improper flare, which resulted in a bounced landing, and the subsequent collapse of the landing gear.Aug 2, 2009 · N551N · Substantial damageNTSB ERA09LA384Accident · No injuriesLimited investigationFinal reportLancair LC42-550FG · Ocean City, NJAn in-flight collision with birds during landing. Contributing to the accident was the airport's lack of a wildlife mitigation program.Jul 4, 2009 · N6502A · Substantial damageNTSB ERA09CA336Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Somerville, NJThe loss of directional control during the landing roll due to the separation of the tailwheel centering spring for an undetermined reason.Jun 8, 2009 · N43766 · Substantial damageNTSB ERA09CA322Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Caldwell, NJThe pilot’s failure to maintain directional control of the airplane during landing. Contributing to the accident was the pilot’s failure to ensure that he could operate the rudder pedals without interference.May 31, 2009 · N811SA · Substantial damageNTSB ERA09LA204Accident · No injuriesLimited investigationFinal reportFlight Design Ctls · Pittstown, NJThe pilot's inadequate compensation for the crosswind during landing.Mar 18, 2009 · N471CT · Substantial damageNTSB ERA09CA190Accident · No injuriesData collectionFinal reportPiper PA-42 · Belmar, NJThe pilot's improper flare, which resulted in a hard landing.Mar 9, 2009 · N28DA · Substantial damage