NTSB investigations, 2022

12 cases where NTSB found Operating environment.

Cases per year

20082026
NTSB investigations, 2022 per year, 2008–2026: 293 cases
200873
200919
201019
201112
201219
201313
201419
201517
201613
201710
20185
201910
20204
202113
202212
202310
202411
202510
20264

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\") = 2022
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0301'))
  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 ERA23LA094Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Franklin, VAThe pilot’s failure to maintain clearance from trees during the initial climb following an aborted precautionary landing. Contributing to the outcome were the inoperative runway lights, which reduced the likelihood that the pilot could successfully land the…Dec 26, 2022 · N177D · Substantial damageNTSB WPR23LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA42 · Lewistown, MTThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the out of service visual glideslope indicator and snow obscuring the runway markings.Dec 13, 2022 · C-GZPU · Substantial damageNTSB CEN23LA015Accident · No injuriesClass 4 · LimitedFinal reportBeech B-60 · Ardmore, OKThe pilot did not ensure adequate clearance from construction vehicles during taxi.Oct 13, 2022 · N2889W · Substantial damageNTSB ERA22LA409Accident · No injuriesClass 4 · LimitedFinal reportCessna 182N · Blairstown, NJThe pilot’s decision to cross the taxiway at an unsuitable location.Sep 4, 2022 · N8942G · Substantial damageNTSB CEN22LA411Accident · No injuriesClass 4 · LimitedFinal reportCessna T210L · Atoka, OKThe pilot's failure to land the airplane within the desired touchdown zone, which resulted in a long landing and collision with a fence.Aug 24, 2022 · N2317G · Substantial damageNTSB ERA22FA318Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-46-350P · North Las Vegas, NVThe low-wing airplane pilot’s failure to ensure that the airplane was aligned with the correct runway, which resulted in a collision with the high-wing airplane on final approach. Contributing to the accident was the controller’s failure to provide timely and…Jul 17, 2022 · N97CX · 2 aircraft · DestroyedNTSB ERA22LA433Accident · No injuriesClass 4 · LimitedFinal reportEaster William C M-1 · Okeechobee, FLThe premature placement of an airport runway closure marker short of the runway, which resulted in the airplane’s collision with the marker during the landing approach. Contributing was the pilot’s inability to see the marker due the nose-high attitude of the…Jul 16, 2022 · N150MM · Substantial damageNTSB WPR22LA251Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 208B · Salt Lake City, UTThe pilot’s inability to maintain control of the airplane when it encountered a microburst during a landing attempt and a go-around near known thunderstorm activity. Contributing to the accident was an inadequate amount of wind sensors and wind shear…Jul 14, 2022 · N877FE · Substantial damageNTSB CEN22LA310Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Wyoming, ILThe pilot’s improper landing flare, which resulted in a hard, bounced landing.Jul 10, 2022 · N205SK · Substantial damageNTSB CEN22LA293Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Bynum, TXThe pilot was not able to stop the airplane on the remaining runway after an aborted takeoff, which resulted in a runway excursion and the airplane impacting a fence.Jun 17, 2022 · N2975U · Substantial damageNTSB CEN22LA171Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Peyton, COThe pilot’s decision to not activate the runway lighting and misjudged the runway location, which resulted in a collision with a windsock.Apr 8, 2022 · N248G · Substantial damageNTSB CEN22LA126Accident · No injuriesClass 4 · LimitedFinal reportEmbraer Executive EMB-500 · Detroit, MIThe pilot’s decision to land on the contaminated runway with previous reports of unfavorable braking action.Feb 18, 2022 · N68NH · Substantial damage