NTSB investigations: Boeing 747-131, NY
7 cases on aircraft the registry lists as Boeing 747-131. 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.
Cases per year
| 1970 | 2 |
|---|---|
| 1972 | 1 |
| 1977 | 1 |
| 1987 | 1 |
| 1994 | 1 |
| 1996 | 1 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'NY' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1384881'))
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" = 'NY' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1384881'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 DCA96MA070Accident · 230 fatalClass 1 · MajorFinal reportBoeing 747-131 · East Moriches, NYAn explosion of the center wing fuel tank (CWT), resulting from ignition of the flammable fuel/air mixture in the tank. The source of ignition energy for the explosion could not be determined with certainty, but, of the sources evaluated by the investigation,…NTSB NYC95IA043Incident · No injuriesIncident investigationFinal reportBoeing 747-131 · Jamaica, NYImproper maintenance overhaul which resulted in a fatigue crack.NTSB NYC87IA227Incident · No injuriesIncident investigationFinal reportBoeing 747 · New York, NYAcft with similar call signs (twa flts 843H & 834; Boeing 747 & Boeing 727) apchd jfk intl arpt for ldg. Flt 843H was 22MIN late & flt 834 was 12 min early, causing same arr time. NY TRACON vctrd flt 834 bhnd flt 843H. While ctlg the acft, jfk final ctlr,…NTSB NYC77IA091Incident · No injuriesClosedBoeing 747 · Jamaica, NYNTSB NYC73AN040Accident · Serious injuriesClosedBoeing 747 · Jamaica, NYNTSB NYC71IN039Incident · No injuriesClosedBoeing 747 · Jamaica, NYNTSB NYC70IN127Incident · No injuriesClosedBoeing 747 · Jamaica, NY