NTSB investigations: Boeing 747-151

10 cases on aircraft the registry lists as Boeing 747-151. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19702026

NTSB investigations: Boeing 747-151 per year, 1970–2026: 10 cases
1970	2
1971	3
1972	1
1973	1
1974	1
1981	1
1991	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1384891')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1384891'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1384891'))
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 SEA91IA219Incident · Minor injuriesIncident investigationFinal reportBoeing 747-151 · Seattle, WAA fire in the number 4 engine, resulting from a fuel leak at the main fuel control unit, due to improper maintenance by unknown/undetermined person. The L5 emergency exit failed to operatee due to a broken plastic pulley guard in the slide release mechanism.Aug 22, 1991 · N604US · Minor damage NTSB DEN81FA018Accident · No injuriesClosedBoeing 747 · Fargo, NDFeb 11, 1981 · N610US · Substantial damage NTSB NYC75AN065Accident · No injuriesClosedBoeing 747 · Jamaica, NYNov 21, 1974 · N604US · 2 aircraft · Minor damage NTSB MIA73AM050Accident · Serious injuriesClosedBoeing 747 · Tallahassee, FLApr 26, 1973 · N601US · No damage NTSB OAK72AP039Accident · Serious injuriesClosedBoeing 747 · N.Pacific Ocean (Pacific Ocean)May 6, 1972 · N605US · No damage NTSB SEA72IS014Incident · No injuriesClosedBoeing 747 · Seattle, WAOct 9, 1971 · N601US · Minor damage NTSB MIA71IM099Incident · No injuriesClosedBoeing 747 · Miami, FLMay 20, 1971 · N604US · No damage NTSB DCA71I0004Incident · No injuriesClosedBoeing B747 · Honolulu, HIMay 13, 1971 · N607US · Minor damage NTSB MKC70IK070Incident · No injuriesClosedBoeing 747 · Salina, KSJun 11, 1970 · N603US · Minor damage NTSB MKC70IK065Incident · No injuriesClosedBoeing 747 · Salina, KSMay 26, 1970 · N601US · Minor damage