NTSB investigations, 2008, FL

12 cases where the sequence of events included Sys/Comp malf/fail (non-power).

Cases per year

20082026
NTSB investigations, 2008, FL per year, 2008–2026: 69 cases
200812
20096
20101
20116
20121
20133
20143
20153
20162
20171
20195
20204
20217
20221
20231
20248
20252
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\") = 2008
    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\" = '330' 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 ERA09IA115Incident · No injuriesIncident investigationFinal reportCessna 402C · Fort Lauderdale, FLThe airplane manufacturer's inadequate inspection procedure resulting in undetected fatigue cracking of the main landing gear barrel of the upper barrel and trunnion assembly.Dec 11, 2008 · N522FA · Minor damageNTSB ERA09LA001Accident · Serious injuriesLimited investigationFinal reportBezinque Alisport-Silent · Vero Beach, FLThe failure of the electric fuel boost pump which resulted in a loss of engine power due to fuel starvation.Oct 1, 2008 · N373DB · Substantial damageNTSB NYC08CA297Accident · No injuriesData collectionFinal reportErcoupe 415-C · Sebring, FLA bird strike which substantially damaged the propeller and required the engine to be secured. Contributing to the accident was the damaged propeller.Aug 29, 2008 · N87376 · Substantial damageNTSB NYC08CA252Accident · Minor injuriesData collectionFinal reportBuschmann Robert E Helicycle · Stuart, FLThe pilot's improper decision to take off with a known discrepancy. Contributing to the accident was spilled fuel on the drive belts.Jul 19, 2008 · N3375C · Substantial damageNTSB NYC08CA205Accident · No injuriesData collectionFinal reportLuscombe 8A · Indiantown, FLAn inadequate annual inspection that failed to detect a damaged rudder cable which resulted in the cable's subsequent failure during takeoff.Jun 3, 2008 · N37012 · Substantial damageNTSB MIA08CA088Accident · Serious injuriesData collectionFinal reportWilliam E. Furr SeaRey · Winter Springs, FLThe pilot's inadequate preflight inspection of the airplane.Apr 10, 2008 · N815Z · Substantial damageNTSB CHI08LA104Accident · No injuriesLimited investigationFinal reportVic Tatelman Baby Belle · Lakeland, FLThe failure of the tailrotor driveshaft hanger bearing and jamming of the tailrotor.Apr 9, 2008 · N6261N · Substantial damageNTSB MIA08LA079Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe improper adjustment of the right main landing gear down lock by maintenance personnel resulting in the gear collapse during the landing roll..Mar 15, 2008 · N300SH · Substantial damageNTSB MIA08CA074Accident · No injuriesData collectionFinal reportCessna 525B · Stuart, FLThe flight crew's failure to reset the brakes circuit breaker resulting in a loss of brakes during taxi and an on ground collision with an unoccupied parked airplane.Mar 8, 2008 · N400GG · Substantial damageNTSB MIA08LA066Accident · No injuriesLimited investigationFinal reportCessna 210L · Tampa, FLThe malfunction of the right main landing gear down-and-locked switch.Feb 27, 2008 · N5489V · Substantial damageNTSB NYC08LA091Accident · Minor injuriesLimited investigationFinal reportNorth American Rockwell NA-265-80 · Ft. Lauderdale, FLThe depletion of pressure in the normal hydraulic system for an undetermined reason, and the pilots' failure to properly operate the emergency braking system. Contributing to the accident was an inoperative hydraulic system aural warning.Feb 1, 2008 · N3RP · Substantial damageNTSB ENG08IA011Incident · Minor injuriesIncident investigationFinal reportBoeing B757-200 · West Palm Beach, FLthe arcing of the windshield heat system at the upper, aft (J1) and upper, forward (J4) terminal locations on the first officer's windshield, which caused the inner pane of glass to fracture.Jan 31, 2008 · N624AA · Minor damage