NTSB investigations, 2018, VA

7 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
NTSB investigations, 2018, VA per year, 2008–2026: 69 cases
20082
20095
20105
20116
20125
20135
20144
20156
20162
20174
20187
20191
20205
20211
20222
20244
20254
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\") = 2018
    AND c.\"eventStateOrRegion\" = 'VA' 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\" = '440' 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 ERA19LA033Accident · No injuriesLimited investigationFinal reportPiper PA28 · New Market, VAA loss of engine power on takeoff due to restricted air flow to the engine.Oct 25, 2018 · N68DW · Substantial damageNTSB ERA19LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Lynchburg, VAThe stuck No. 2 cylinder exhaust valve, which resulted in a partial loss of engine power and a subsequent forced landing and impact with a ditch.Oct 18, 2018 · N924MM · Substantial damageNTSB GAA18CA537Accident · No injuriesData collectionFinal reportCessna 180 · Richmond, VAThe pilot's improper preflight fuel planning and in-flight fuel management, which resulted in fuel exhaustion and the total loss of engine power.Sep 5, 2018 · C-GODA · Substantial damageNTSB GAA18CA431Accident · Minor injuriesData collectionFinal reportCessna 172 · King and Queen, VAThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Jul 5, 2018 · N1401F · Substantial damageNTSB ERA18LA169Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172D · Quinton, VAA loss of engine power for reasons that could not be determined based on the available evidence.Jun 16, 2018 · N2777U · Substantial damageNTSB ERA18TA142Accident · Minor injuriesFinal reportBarry Maggio Apollo AG-1 · Smith Beach, VAThe noninstrument-rated pilot's inadequate preflight and in-flight weather planning, which resulted in an off-airport precautionary landing to avoid weather and a subsequent collision with power lines.May 6, 2018 · N141C · Substantial damageNTSB ERA18LA101Accident · No injuriesLimited investigationFinal reportPiper PA28 · Chesapeake, VAThe pilot's failure to apply carburetor heat during the approach for a touch-and-go landing, which resulted in a total loss of engine power during the subsequent takeoff.Mar 13, 2018 · N5646V · Substantial damage