Skip to content

NTSB investigations · 21

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 ('5260106') 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 ('5260106')
  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 ('5260106')
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 IAD97FA065Accident · 2 fatalField investigationFinal reportLockheed PV2 · Blandburg, PAPilot in command misjudged his maneuvering altitude. Factors to this accident were the mountainous terrain, windy conditions, turbulence in the area, and smoke.Apr 20, 1997 · N6856C · Destroyed NTSB FTW94LA319Accident · No injuriesLimited investigationFinal reportLockheed PV-2 · Lafayette, LAThe pilot's inadvertent gear retraction.Sep 30, 1994 · N6857C · Substantial damage NTSB LAX90FA336Accident · 8 fatalField investigationFinal reportLockheed PV-2 · Lakeport, CAThe pilot-in-command's failure to maintain airspeed during a pull-up from a low pass. Factors which contributed to the accident were: the pilot's poor judgement in buzzing the seaplanes which resulted in insufficient altitude to recover from the stall, and…Sep 29, 1990 · N7250C · Destroyed NTSB FTW90DRA10Accident · No injuriesFinal reportLockheed PV-2 · Conroe, TXThe engine starter remained engaged after engine start and the electrical system overheat.Sep 16, 1990 · N7428C · Destroyed NTSB LAX85LA235Accident · No injuriesLimited investigationFinal reportLockheed PV-2 · Mesa, AZFollowing a dural engine chang, the plt test flew the acft. On initial climb, at about 500 ft AGL, both engines began backfiring violently & lost power. According to the plt, power sufficient for flt could not be obtained, & a forced ldg was made about 0.75…May 1, 1985 · N7415C · Substantial damage NTSB NYC80FGT11Accident · No injuriesClosedLockheed PV-2 · Philipsburg, PAMay 2, 1980 · N7086C · Substantial damage NTSB DEN79FA047Accident · No injuriesClosedLockheed PV-2 · Humble City, NMJun 26, 1979 · N7253C · Substantial damage NTSB FTW75FPA25Accident · Serious injuriesClosedLockheed PV-2 · Addison, TXApr 28, 1975 · N230Z · Destroyed NTSB LAX74FUJ68Accident · 2 fatalClosedLockheed PV-2 · Winslow, AZJun 12, 1974 · N7263C · Destroyed NTSB MIA70F0134Accident · No injuriesClosedLockheed PV-2 · Macon, GAMay 20, 1969 · N7273C · Substantial damage NTSB MIA70F0040Accident · Serious injuriesClosedLockheed PV-2 · Sebring, FLMay 5, 1969 · N7260C · Destroyed NTSB MIA68A0080Accident · No injuriesClosedLockhead PV-2 · Macon, GAMar 26, 1968 · N7414C · Substantial damage NTSB LAX68A0034Accident · Minor injuriesClosedLockheed PV-2 · Palm Sprngs, CASep 23, 1967 · N7436C · Destroyed NTSB MIA67A0130Accident · No injuriesClosedLockheed PV-2 · Kissimmee, FLJun 29, 1967 · N83L · Substantial damage NTSB ANC67A0063Accident · 1 fatalClosedLockheed PV-2Jun 12, 1967 · N7266C · Destroyed NTSB DEN66A0057Accident · 2 fatalClosedLockheed PV-2 · Phoenix, AZFeb 3, 1966 · N7258C · Destroyed NTSB MIA66A0040Accident · No injuriesClosedLockheed PV-2 · Tupelo, MSOct 11, 1965 · N7254C · Substantial damage NTSB OAK66A0008Accident · 2 fatalClosedLockheed PV-2 · Hayward, CASep 7, 1965 · N7671C · Destroyed NTSB MIA65A0102Accident · No injuriesClosedLockheed PV-2 · Bainbridge, GAApr 17, 1965 · N7260C · Substantial damage NTSB MIA65A0097Accident · No injuriesClosedLockhead PV-2 · Laurel, MSMar 28, 1965 · N7260C · Substantial damage NTSB UNK64X1269Accident · Minor injuriesClosedLockheed PV2 · Hilo Hawaii (Pacific Ocean)Apr 11, 1964 · N375TM · Destroyed

Back to Lockheed PV-2