NTSB investigations, NJ
6 cases where the first occurrence was “Fire”.
Cases per year
| 1982 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1993 | 1 |
| 2005 | 2 |
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\" = 'NJ' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 171)
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" = 'NJ' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 171) 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 NYC05LA131Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Farmingdale, NJA fire that originated at the right main landing gear brake caliper and piston, during taxi, which resulted in substantial damage to the airplane.NTSB IAD05LA095Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Branchville, NJAn electrical fire of unknown origin. A factor in the accident was the pilot's failure to perform the In-Flight Electrical Fires checklist.NTSB BFO93LA118Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Flemington, NJThe passenger's inadvertent activation of the burner after the landing, causing the terrain to burn and subsequently igniting the Balloon envelope.NTSB NYC88LA058Accident · No injuriesLimited investigationFinal reportCessna 182 · Hammonton, NJThe aircraft had taxied to the runup area and during this process of engine runup, the pilot stated that the engine was running rough on one magneto but smooth on the other. The carburetor mixture was leaned but the engine quit. When an attempt to restart was…NTSB NYC86LA156Accident · No injuriesLimited investigationFinal reportBeech B-60 · Toms River, NJAn inflight fire occurred shortly after takeoff. Smoke was observed trailing from the right eng & it was shut down. The plt returned & landed at the arpt. After landing, the fire was extinguished by linemen, a fireman & plts who were standing by. An…NTSB NYC82DA214Accident · No injuriesFinal reportAero Commander 112TC · Morristown, NJWhen pilot extended gear for landing a fire started. The fire continued after landing and pilot was unable to extinguish it. Fire department arrived within 30 minutes but aircraft was destroyed.