OpenAirDocs.org

NTSB investigations, 2023, NE

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19622026

Where

Open the map

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\") = 2023
    AND c.\"eventStateOrRegion\" = 'NE' AND c.\"eventCountry\" = 'USA'
  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 CEN24FA028Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46 · McCook, NEThe pilot exceeded the airplane’s critical angle of attack during the initial climb, resulting in an aerodynamic stall from which he could not recover. Contributing to the accident was the pilot’s decision to take off with the airplane well above its maximum…Oct 30, 2023 · N510KC · Substantial damageNTSB CEN23LA357Accident · No injuriesClass 4 · LimitedFinal reportPiper PA25 · Hartington, NEThe pilot’s misperception of the rising terrain resulting in a collision with crops and terrain.Aug 8, 2023 · N8847L · Substantial damageNTSB CEN23LA297Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Boelus, NELoss of engine power for reasons that could not be determined.Jul 12, 2023 · N151SR · Substantial damageNTSB CEN23LA232Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Bloomfield, NEA partial loss of engine power during takeoff for reasons that could not be determined.Jun 7, 2023 · N48485 · Substantial damageNTSB CEN23FA220Accident · 1 fatalClass 3 · FieldFinal reportVans RV7 · Gibbon, NEThe pilot’s improper decision to fly the airplane into known adverse weather and icing conditions which resulted in a loss of control.Jun 2, 2023 · N977RV · DestroyedNTSB CEN23FA187Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Chambers, NEThe pilot’s continued VFR flight into instrument meteorological conditions at night and his failure to maintain adequate altitude, which resulted in controlled flight into terrain.May 15, 2023 · N2946U · Substantial damageNTSB CEN23LA171Accident · No injuriesClass 4 · LimitedFinal reportKitfox IV · Gretna, NEThe pilot’s failure to maintain clearance from terrain during a turn immediately after takeoff.May 4, 2023 · N440RS · Substantial damageNTSB CEN23LA137Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-46-600TP · Thedford, NEOn March 4, 2023, about 1437 central standard time, a Piper PA46-600TP, N131HL, sustained substantial damage when it was involved in an accident near Thedford, Nebraska. The pilot and passenger were uninjured. The airplane was being operated as a Title 14…Mar 4, 2023 · N131HL · Substantial damageNTSB CEN23LA090Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Hyannis, NEThe pilot’s failure to maintain clearance from a snowbank during landing, which resulted in a nose-over.Jan 20, 2023 · N717DJ · Substantial damageNTSB CEN23FA077Accident · 2 fatalClass 3 · FieldFinal reportCessna 150H · Auburn, NEThe flight instructor’s failure to maintain control after a loss of engine power due to carburetor icing while maneuvering for forced landing in dark night visual meteorological conditions.Jan 12, 2023 · N22859 · Substantial damage