NTSB investigations, FL

4 cases where the first occurrence was “Propeller blast or jet exhaust/suction”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19872026

NTSB investigations, FL per year, 1987–2026: 4 cases
1987	1
1989	1
1991	1
1998	1

Where

Open the map

Latest cases

Query with SQL

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 c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 360) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 360)
  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.

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 c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 360)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB MIA98LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe CFI's improper planning and decision to taxi behind a multi-engine airplane conducting an engine run-up.Feb 8, 1998 · N89051 · Substantial damage NTSB MIA91LA120Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Lakeland, FLImproper ATC clearance by ground personnel and poor decision by the pilot to taxi behind an airplane holding on a runway.Apr 10, 1991 · N6040V · Substantial damage NTSB MIA89LA119Accident · No injuriesLimited investigationFinal reportBoeing E75N1 · Stuart, FLInadequate visual lookout by both the pilot of the Boeing E75N1 and the person running up the OV-1 (their failure to see each other and avoid the occurrence).Mar 31, 1989 · N53549 · Substantial damage NTSB MIA87LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Miami, FLA us customs blackhawk helicopter intercepted the acft after mistakenly identifing it as a suspected drug smuggling acft. After the acft landed at a gliderport on the edge of the everglades, the helicopter swooped down in the vicinity of the acft & blew it…Jul 9, 1987 · N6852J · Substantial damage