NTSB investigations, 2018, FL

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

Cases per year

20082026
NTSB investigations, 2018, FL per year, 2008–2026: 335 cases
200812
200928
201019
201122
201225
201322
201422
201521
201621
201717
201818
201919
20208
202116
202216
20238
202420
202518
20263

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\" = 'FL' 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 ERA19LA081Accident · No injuriesLimited investigationFinal reportCessna LC41 · Apopka, FLA partial loss of engine power during a go-around for reasons that could not be determined based on the available information, which resulted in a forced landing.Dec 31, 2018 · N78JE · Substantial damageNTSB ERA19LA079Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Lauderdale, FLA total loss of engine power due to the fatigue fracture of the No. 2 exhaust rocker arm stud.Dec 24, 2018 · N3015E · Substantial damageNTSB ERA19LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Bell Glade, FLA partial loss of engine power due to the No. 1 cylinder's valve keeper becoming dislodged, which ultimately resulted in the intake valve becoming stuck in the valve guide and in the loss of compression to the cylinder.Dec 17, 2018 · N4886B · Substantial damageNTSB ERA19LA065Accident · Minor injuriesClass 3 · LimitedFinal reportCzech Sport Piper Sport · Punta Gorda, FLA total loss of engine power due to an interruption of fuel flow.Dec 13, 2018 · N145MM · Substantial damageNTSB ERA19FA060Accident · 2 fatalClass 2 · FieldFinal reportCessna 335 · Fort Lauderdale, FLThe pilot's improper decision to fly the unairworthy airplane and his failure to feather the left propeller following a partial loss of power from the left engine after takeoff. Also causal was the partial loss of power to the left engine due to detonation.Dec 1, 2018 · N79HP · DestroyedNTSB ERA19FA048Accident · 1 fatalField investigationFinal reportVans RV-12 · Niceville, FLA partial loss of engine power during initial climb for undetermined reasons, and pilot's failure to maintain airspeed during a turn back to the runway, which resulted in an exceedance of the airplane's critical angle of attack, and subsequent aerodynamic…Nov 17, 2018 · N232VA · Substantial damageNTSB GAA19CA070Accident · No injuriesData collectionFinal reportCessna T337 · Homosassa, FLThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion and the subsequent total loss of power in both engines.Nov 8, 2018 · N1ZR · Substantial damageNTSB ERA19LA021Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Plant City, FLThe pilot’s failure to utilize carburetor heat in conditions conducive to the formation of carburetor icing, which resulted in a total loss of engine power.Oct 18, 2018 · N3631K · Substantial damageNTSB ERA18LA265Accident · Minor injuriesLimited investigationFinal reportPiper PA32 · Bartow, FLA total loss of engine power after the separation of the No. 3 cylinder from the crankcase due to improper maintenance.Sep 28, 2018 · N4592X · Substantial damageNTSB ERA18TA263Accident · Minor injuriesFinal reportZenith CH 750 · DeLeon Springs, FLThe pilot's operation of the airplane with the alternator switch in the off position, which allowed the selected battery to discharge and resulted in an ignition system failure and a total loss of engine power.Sep 23, 2018 · N752VK · Substantial damageNTSB ERA18LA259Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLThe partial loss of engine power due to a fractured exhaust valve, which resulted in a forced landing on unsuitable terrain and a subsequent rollover.Sep 8, 2018 · N6469P · Substantial damageNTSB ERA18TA203Accident · No injuriesFinal reportBeech C90 · Lecanto, FLThe pilot's failure to turn on the fuel transfer pumps in accordance with the published checklists, which resulted in a dual loss of engine power due to fuel starvation.Jul 26, 2018 · N717X · Substantial damageNTSB GAA18CA419Accident · No injuriesData collectionFinal reportCessna 152 · Panama City, FLThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Jun 30, 2018 · N89887 · Substantial damageNTSB WPR18LA183Accident · No injuriesLimited investigationFinal reportCessna 182 · Jacksonville, FLA total loss of engine power for reasons that could not be determined due to insufficient evidence.Jun 23, 2018 · N5682B · Substantial damageNTSB GAA18CA343Accident · Serious injuriesData collectionFinal reportAmerican AA · Port Orange, FLThe pilot’s inadequate preflight inspection of the fuel, which resulted in fuel exhaustion and a subsequent total loss of engine power.May 24, 2018 · N5787L · Substantial damageNTSB ERA18LA145Accident · No injuriesLimited investigationFinal reportPiper PA28 · Vero Beach, FLWater contamination of the fuel supply, which resulted in a total loss of engine power.May 7, 2018 · N80813 · Substantial damageNTSB ERA18LA110Accident · Minor injuriesLimited investigationFinal reportBesarick Skybolt · Punta Gorda, FLA substantial oil leak, which resulted in a partial loss of engine power and failure of the No. 2 connecting rod.Mar 17, 2018 · N27265 · DestroyedNTSB ERA18LA107Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Key West, FLA partial loss of engine power during initial climb for reasons that could not be determined because examination of the wreckage did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.Mar 15, 2018 · N713CX · Substantial damage