Skip to content

NTSB investigations · 27

Matched to the registry by N-number and event date, newest first.

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2073342') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('2073342')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2073342')
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 ANC12LA093Accident · No injuriesLimited investigationFinal reportCessna U206D · Nikolai, AKThe total loss of engine power for reasons that could not be determined because the engine was not made available for examination.Aug 25, 2012 · N729RV · Substantial damage NTSB ANC07FA051Accident · Serious injuriesField investigationFinal reportCessna 206 · Homer, AKA loss of engine power due to fuel starvation from the pilot's improper fuel selector positioning, and her failure to maintain adequate airspeed to preclude a stall. Contributing to the accident was an inadvertent stall.Jun 19, 2007 · N72067 · Substantial damage NTSB LAX01LA225Accident · No injuriesLimited investigationFinal reportCessna U206D · Boulder City, NVthe pilot's inadequate compensation for the tailwind gust and subsequent failure to maintain directional control of the airplane while landing.Jun 28, 2001 · N72218 · Substantial damage NTSB MIA97LA076Accident · No injuriesLimited investigationFinal reportCessna U206D · Tampa, FLInadequate torque of the cylinder base nuts and through bolt nuts by company maintenance personnel which allowed movement of the crankcase halves. As a result the No. 2 main bearing failed which allowed excessive movement of the crankshaft resulting in…Jan 27, 1997 · N72074 · Substantial damage NTSB MIA94LA065Accident · No injuriesLimited investigationFinal reportCessna U-206 · St. Petersburg, FLThe failure of the pilot of the conventional gear airplane to maintain a visual lookout for other aircraft.Feb 3, 1994 · N72074 · 2 aircraft · Substantial damage NTSB FTW93LA031Accident · No injuriesLimited investigationFinal reportCessna U206D · Fort Stockton, TXThe pilot's failure to follow published fuel system sumping procedures before flight and total loss of power due to water contaminated fuel. Factors were the drizzle and icing conditions and the lack of suitable terrain.Nov 4, 1992 · N925RR · Substantial damage NTSB FTW89LA101Accident · No injuriesLimited investigationFinal reportCessna 206D · Saint Jo, TXThe pilot's decision to attempt to takeoff from a field that was not suitable for such purpose.May 27, 1989 · N72279 · Destroyed NTSB DEN89LA018Accident · No injuriesLimited investigationFinal reportCessna U206 · Brush, COFollowing landing at an unattended airport, while back-taxiing, the eng failed. During restart the plt heard a loud 'pop' from the eng compartment followed by white smoke and flame. The plt and pax exited the acft and the plt went to a nearby phone to call…Oct 17, 1988 · N184V · Destroyed NTSB ANC84LA152Accident · No injuriesLimited investigationFinal reportCessna 206 · Nondalton, AKThe acft landed short of the rwy. The wind was from 280 degrees at 12 KTS gusting to 25 KTS. The plt reported that he was caught in a downdraft and full power did not slow the rate of descent.Aug 31, 1984 · N222RG · Substantial damage NTSB ANC81FA075Accident · 5 fatalClosedCessna U206 · Moose Pass, AKJul 1, 1981 · N72258 · Substantial damage NTSB LAX81DVG17Accident · No injuriesClosedCessna U206 · Sacramento, CAFeb 2, 1981 · N184V · Substantial damage NTSB ANC80FA075Accident · Minor injuriesClosedCessna U206 · Kenai, AKJul 28, 1980 · N71961 · Substantial damage NTSB FTW80DA009Accident · No injuriesClosedCessna U206D · Lubbock, TXNov 1, 1979 · N71967 · Substantial damage NTSB ANC78DAG66Accident · Minor injuriesClosedCessna 206 · Icy Bay, AKMay 8, 1978 · N72018 · Substantial damage NTSB ANC77DA070Accident · No injuriesClosedCessna 206E · Tatitlek, AKAug 1, 1977 · N72018 · Substantial damage NTSB ANC77DA037Accident · No injuriesClosedCessna U206D · Flat, AKApr 4, 1977 · N72106 · Substantial damage NTSB DEN77FA027Accident · 3 fatalClosedCessna U206D · Hanna, UTFeb 26, 1977 · N72308 · Destroyed NTSB OAK75OP001Accident · No injuriesClosedCessna 172 · Lingayan, RPJul 12, 1974 · N71992 · Substantial damage NTSB NYC74AN072Accident · 1 fatalClosedCessna U206 · Monon, INFeb 22, 1974 · N71992 · Destroyed NTSB NYC73FIJ11Accident · No injuriesClosedCessna 206D · Dublin, VANov 25, 1972 · N71964 · Substantial damage NTSB NYC72FHM43Accident · No injuriesClosedCessna U206 · Yulan, NYApr 18, 1972 · N72030 · Substantial damage NTSB FTW72DRD21Accident · Minor injuriesClosedCessna U206D · Labadieville, LAMar 23, 1972 · N71994 · Substantial damage NTSB FTW72DPD30Accident · No injuriesClosedCessna U206 · Abilene, TXFeb 16, 1972 · N71996 · Substantial damage NTSB LAX71FUJ85Accident · Minor injuriesClosedCessna U206D · Phoenix, AZApr 12, 1971 · N72045 · Substantial damage NTSB MKC71DDM22Accident · No injuriesClosedCessna U206D · So.St.Paul, MNSep 8, 1970 · N72285 · Substantial damage NTSB FTW70AF066Accident · No injuriesClosedCessna 206 · Jonesboro, ARApr 20, 1970 · N72094 · Substantial damage NTSB MIA70AM070Accident · No injuriesClosedCessna U206D · Memphis, TNFeb 13, 1970 · N71967 · Substantial damage

Back to Cessna U206D